Hi,
I have a formula to change TRUE and FALSE from cells linked to checkboxes to values that can be used in an advanced filter. The only problem is that for an anvanced filter, criteria cannot have blank cells in between.
I'm looking for a formula which will bring back the cell that is the next available value in the column if the current cell is blank to get rid of the blanks
Any ideas? Or a better way to get rid of the blanks?
Bookmarks