How do I find blank cells using AutoFilter's Custom feature?

A

Andrea Blake

I can't get a formula to work in the Custom filter box. I need to filter for
blanks and a text value.
Thanks!
 
P

Peo Sjoblom

Show rows where "name of column" equals
leave the box blank, then click Or and select equals your textstring


Regards,

Peo Sjoblom
 
A

Andrea Blake

Gods! How simple is that! Thank you sooo much, Peo. You have no idea how much
time I've wasted trying to figure that out (and my boss thanks you, too). :))
-Andrea
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Utilizng full AutoFilter features while specific cells are protect 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Utilizng full AutoFilter features while specific cells are protect 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Nested if statements creating a blank cell 1
Calculations of Cell after Autofiltering 0
Count the number of AutoFiltered records 6
How do I filter data by more than one column in excel 0

Top