| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter for "blanks" in multiple columns simultaneously
I'm not sure why you want to filter to show blanks - cos, you wont be
able to see anything !! You could make use of a helper column to see if there are any blanks in any of the cells in that row, eg by putting this in L2: =COUNTIF(A2:K2,"") and copying down, and then you could appy a custom filter to that column for not equal to zero. Hope this helps. Pete On Sep 16, 2:21*pm, confused_in_London wrote: I have a spreadsheet with several columns of data that I need to filter to show blank cells. Is there a way to apply the autofilter to more than one column to save me from filtering each individual column? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
| Make pivot table with multiple "data" fields in columns not rows? | Excel Discussion (Misc queries) | |||
| In Excel how can I filter multiple columns SIMULTANEOUSLY? | Excel Discussion (Misc queries) | |||
| automatically filter out blanks in multiple columns | Excel Worksheet Functions | |||
Hybrid Mode
