Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
Autofilter only works when there is data in continuous rows. If you have an
entirely blank row, Autofilter will not work the way you want. The way I've gotten around this is to add a column and put in a row number or some other data for ALL THE ROWS that I want to review. I'll then use the autofilter to find the cells that are blank. "D Hafer - TFE" wrote: What would I put into an autofilter parameter to show only rows which begin with text or are blank? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
advanced filter - can't match a long text cell | Excel Discussion (Misc queries) | |||
Filter long Text strings | Excel Worksheet Functions | |||
Blank Rows | Excel Discussion (Misc queries) | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |