Advanced Criteria For NonBlanks Help

  • Thread starter Thread starter knowshowrosegrows
  • Start date Start date
K

knowshowrosegrows

I have what I think is a simple question that I need answered IMMEDIATELY.

I have a spreadsheet with 20 fields and I want to filter it so it only shows
records that have something in of any of 5 of those fields. So once
filtered, I will not have any records that have all 5 of those fields blank.

I know I have done this before but I'll be damned if I can remember or find
out how.
 
Something like this in Z2, where Z1:Z2 is the criteria:
=OR(B2<>"",F2<>"",G2<>"",H2<>"",K2<>"")
 

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

Advanced Filter for NonBlanks 1
Criteria for Advanced Filter HELP 5
Filter for blanks - nonblanks problem 1
Looking uprange for next nonblank cell 4
Access Dcount (multiple criteria) 3
Copy only nonblank cells 8
Adding only NONBLANK cells 2
advanced filtering multiple criteria 2

Back
Top