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
|