Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Filtering by criteria in two columns
I'm new to the advanced features of 2003 and I'm having a problem getting a
spreadsheet to filter correctly. I need to filter based on the criteria that a value in one column is equal to "value A" or a value in another column is equal to "value B". Any help would be greatly appreciated. Thanks. Mike |
#2
|
|||
|
|||
I think that you would need to create a helper column that makes those two
test returning True or false, and filter by that column. -- HTH RP (remove nothere from the email address if mailing direct) "bookmike" wrote in message ... I'm new to the advanced features of 2003 and I'm having a problem getting a spreadsheet to filter correctly. I need to filter based on the criteria that a value in one column is equal to "value A" or a value in another column is equal to "value B". Any help would be greatly appreciated. Thanks. Mike |
#3
|
|||
|
|||
Would the auto 'drop down' filter by column work?
I filter multiple columns at work by one filter at a time, depending on the relevancy of the data needed. "Bob Phillips" wrote in message ... I think that you would need to create a helper column that makes those two test returning True or false, and filter by that column. -- HTH RP (remove nothere from the email address if mailing direct) "bookmike" wrote in message ... I'm new to the advanced features of 2003 and I'm having a problem getting a spreadsheet to filter correctly. I need to filter based on the criteria that a value in one column is equal to "value A" or a value in another column is equal to "value B". Any help would be greatly appreciated. Thanks. Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum Count of Single Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
SUMIF using two columns in both Range and Criteria | Excel Worksheet Functions | |||
SUMIF in multiple columns based on other criteria in Excel? | Excel Discussion (Misc queries) | |||
Filtering Text Data from Multiple columns | Excel Worksheet Functions |