Removing

Blank Cells

There are a number of different ways you can remove blank cells from a list

1) Using GoTo Special Dialog Box

2) Using Find (lookin 'values')

3) Using a Formula / Array Formula
Formulas > Array Formulas > Removing Blanks

4) Using a User Defined Function
NONBLANKVALUES - Returns a cell range with all the blanks removed.

5) Using VBA Code
Range("A1").specialcells(xlcelltypeblanks).delete

Duplicate Cells