Criteria for Advanced Filter HELP
 

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.

--
Thanks

You all are teaching me so much

Criteria for Advanced Filter HELP
 

don't cross-post -- answer supplied in misc NG

"knowshowrosegrows" wrote in
message ...
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.

--
Thanks

You all are teaching me so much

Criteria for Advanced Filter HELP
 

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" wrote:

don't cross-post -- answer supplied in misc NG

"knowshowrosegrows" wrote in
message ...
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.

--
Thanks

You all are teaching me so much

Criteria for Advanced Filter HELP
 

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" wrote in
message ...
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" wrote:

don't cross-post -- answer supplied in misc NG

"knowshowrosegrows" wrote
in
message ...
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.

--
Thanks

You all are teaching me so much

Criteria for Advanced Filter HELP
 

I am saying that I read your answer and I don't understand it.
--
Thanks

You all are teaching me so much


"Bob Umlas" wrote:

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" wrote in
message ...
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" wrote:

don't cross-post -- answer supplied in misc NG

"knowshowrosegrows" wrote
in
message ...
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.

--
Thanks

You all are teaching me so much

Criteria for Advanced Filter HELP
 

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
---