Criteria for Advanced Filter 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.
 
I don't mean to sound flip. I really don't but I don't understand your
response in "NG." And I honestly don't even know how to articulate what I
don't understand about it. I was hoping someone else would answer that would
give more detail.

I am trying to do an advanced filter.

My list range is $A$15:$AJ$875
The cells where I have my criteria range is $AB$1:$AJ$10

I have tried putting ="<>""" in AB2, AC3, AD4, AE5, AF6, AG7, AH8, AI9, and
AJ10. It seems that it just coies the whole list range to the destination.
I still have lots of records that have blanks in fields AB to AJ.

--
Thanks

You all are teaching me so much


Bob Umlas said:
don't cross-post -- answer supplied in misc NG
Click to expand...
 
NG = NewsGroup
I gave the answer in Microsoft.public.excel.misc, where you posted it as
well as here (microsoft.public.excel.newusers), meaning you posted it twice,
and that's not the "proper" etiquette, only because you may get 2 or more
people spending time answering your question only to find it's already been
answered.
My answer in the other section was:

Something like this in Z2, where Z1:Z2 is the criteria:
=OR(B2<>"",F2<>"",G2<>"",H2<>"",K2<>"")

knowshowrosegrows said:
I don't mean to sound flip. I really don't but I don't understand your
response in "NG." And I honestly don't even know how to articulate what I
don't understand about it. I was hoping someone else would answer that
would
give more detail.

I am trying to do an advanced filter.

My list range is $A$15:$AJ$875
The cells where I have my criteria range is $AB$1:$AJ$10

I have tried putting ="<>""" in AB2, AC3, AD4, AE5, AF6, AG7, AH8, AI9,
and
AJ10. It seems that it just coies the whole list range to the
destination.
I still have lots of records that have blanks in fields AB to AJ.
Click to expand...
 
Maybe simpler just to use autofilter on a helper col

Assume your 20 cols in cols A to T, data from row2 down
In say, U2: =COUNTA(A2:T2)>=5
Copy U2 down. Then apply autofilter on col U, choose: TRUE

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
 
Back
Top