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

Duplicate Cells

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