EXCEL MULTIPLE FILTER

J

JulieD

Hi

Have you tried Data / Filter / AutoFilter?
if this didn't meet your needs could you explain why in a bit more detail

Regards
JulieD
 
J

jeremiah256

Hi all,

Looking to solve a problem:

I have a large spreadsheet that I need to filter for various values. I
investigated the "Sort" function but I need more. I need to be able to
pick several different values from a column and to show their complete
fields.

Any MOUS out there with the answer?

Thanks in advance.
 
D

Debra Dalgleish

If you want to use more than two criteria in a column, you could use an
Advanced Filter. There are instructions in Excel's Help, and here:

http://www.contextures.com/xladvfilter01.html

Or, you could add another column to the table, and use an OR formula to
check for multiple values. For example:

=OR(G2="Pen",G2="Pencils",G2="Desk")

Copy the formula down to the last row of data, then filter the column
for TRUE.

Or enter the criteria items in a list, and use a COUNTIF formula to test
the record. For example: =COUNTIF($L$1:$L$7,G2)
Copy the formula down to the last row of data, then filter the column for 1.
 
J

jeremiah256

Debra Dalgleish said:
If you want to use more than two criteria in a column, you could use an
Advanced Filter. There are instructions in Excel's Help, and here:

http://www.contextures.com/xladvfilter01.html

Or, you could add another column to the table, and use an OR formula to
check for multiple values. For example:

=OR(G2="Pen",G2="Pencils",G2="Desk")

Copy the formula down to the last row of data, then filter the column
for TRUE.

Or enter the criteria items in a list, and use a COUNTIF formula to test
the record. For example: =COUNTIF($L$1:$L$7,G2)
Copy the formula down to the last row of data, then filter the column for 1.
Click to expand...

All,

Thanks for all your help. Advanced Autofilter was the answer.

Jeremiah
 
Top