Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter using a range name as the criteria | Excel Worksheet Functions | |||
Advanced filter criteria | Excel Discussion (Misc queries) | |||
Advanced filter criteria | Excel Discussion (Misc queries) | |||
Advanced Filter criteria (formula) | Excel Worksheet Functions | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |