auto filter through blank cells

[dwojtowi]

I have a form with blank rows (used to divide sections)
When i turn on the auto filter, the selections in the pulldown men
only includes the cells from the first block of cells - i.e. it stop
filtering when the first blank cell is reached.

Is there a way to make the filter see past the blank cells?

Thanks!!
Dav

 

[Domenic]

Hi Dave,

There might be a better way to deal with this, but you might want to try
using a helper column. Enter this formula in a column and copy it down:

=IF(B2,TRUE)

You should now be able to filter all of your data.

Hope this helps!

 

[Bob Umlas]

Select all the rows before putting on the autofilter.