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





© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext