Filtering

  • Thread starter Thread starter Jeremy
  • Start date Start date
J

Jeremy

How can I filter an entire sheet for all instances where H2 (and on down) =
NO and I2 (and on down) is non blank?
 
Hi

Use AutoFiler.

Select column H and I then goto Data > Filter > AuroFilter > Ok

At the top to the columns is a drop down field, click on the one in column H
first and select NO, then click on the drop down field in column I and
select NonBlanks.

Regards,
Per
 
You must log in or register to reply here.

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

Complex Question on Filtering on a merged column 1
Help Writing a SUM Formula 5
Conditional formating 3
Sum of multiple rows, based on date criteria, separate sheets... 0
HELP! IF Statements Comparing Date/Time Entries (yyyy-mm-dd hh:mm 1
How do I add a formula to a macro? 4
How to find first row where condition is true? 12
Force a filter beyond blank rows 1

Back
Top