Home |
Search |
Today's Posts |
#6
![]() |
|||
|
|||
![]() Found them Nick. Brilliant!! Thanks again, Paul -- -- paul<dotmoore@pandora<dotbe Adjust "dots" for real address "Nick Hodge" wrote in message ... Paul If you look at the bottom of the autofilter drop-down, you have the options 'Blanks' and 'Non-Blanks' (If they exist) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Paul Moore" wrote in message ... Nick and Earl, Many thanks for your help ( and the very quick response!) A further question: Is it possible to filter such that only rows containing a blank cell are displayed? I suppose I want to do something like Include row if ISBLANK(M7:M300) Thanks again, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Auto Skipping and protected cells | Excel Discussion (Misc queries) |