Filtering by criteria in two columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advanced Filter - Exclude two criteria in separate columns 2
Filtering Using Values In A Specific Cell 3
VBA: How can I use a string variable as autofilter criteria? 4
need help on either doing a loop and counting specific values orusing subtotal function 2
Sumproduct excluding multiple criteria 8
SUM multiple criteria 1
Summing cells based on mulitiple criteria over mulitple columns 0
FILTERING DATA VALUES 1

Back
Top