| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter for blank fields in multiple rows
I need to filter for blank cells. It will usually be a single criteria in
more than one column. It will be 'and'. I know that I have to place all criteria in the same row for 'and'. However, I can't seem to filter out the blank cells. I keep getting nothing or everything. What is the correct method for filtering for blank cells? Thx, Ron |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Advanced Filter for blank fields in multiple rows
Hi,
Show us a sample of your data and the desired results. Are you trying to filter where two columns both contain blanks at the same time or where one or the other contains blanks, it's not clear. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "ronlaforce" wrote: I need to filter for blank cells. It will usually be a single criteria in more than one column. It will be 'and'. I know that I have to place all criteria in the same row for 'and'. However, I can't seem to filter out the blank cells. I keep getting nothing or everything. What is the correct method for filtering for blank cells? Thx, Ron |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Advanced Filter for blank fields in multiple rows
In the criteria range, add the same heading as the column you want to
filter in the table. In the cell below, type: ="=" Include that heading and formula in your criteria range when you run the Advanced Filter There are other criteria examples he http://www.contextures.com/xladvfilter02.html ronlaforce wrote: I need to filter for blank cells. It will usually be a single criteria in more than one column. It will be 'and'. I know that I have to place all criteria in the same row for 'and'. However, I can't seem to filter out the blank cells. I keep getting nothing or everything. What is the correct method for filtering for blank cells? Thx, Ron -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Advanced Filter for blank fields in multiple rows
Shane & Debra,
Thank you for your help. It worked. Just what was needed. "ronlaforce" wrote: I need to filter for blank cells. It will usually be a single criteria in more than one column. It will be 'and'. I know that I have to place all criteria in the same row for 'and'. However, I can't seem to filter out the blank cells. I keep getting nothing or everything. What is the correct method for filtering for blank cells? Thx, Ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find blank with Advanced Filter | Excel Discussion (Misc queries) | |||
| advanced filter looking for blank cells | Excel Discussion (Misc queries) | |||
| Advanced Filter for multiple criteria, including blank cells | Excel Worksheet Functions | |||
| Use Advanced Filter to Detect non blank rows | Excel Discussion (Misc queries) | |||
| How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
Linear Mode
