Auto Filter

  • Thread starter Thread starter lehigh
  • Start date Start date
L

lehigh

Hi All:

Is it possible custom auto filter to find more than 2 objects?
or
Is it possible to conditional format more than three?

I have a column which contains 10 to 30 letter codes;

ie: A, B, C, D, E, etc......................

I am looking for a certain combination of letters.

I would like to filter it, but if I can't, I would like to color it.

Thanks for your help

Tom Snyder
 
One option is to add a column to the table, and use a formula to check
for the criteria.

Start by listing the letters that you want to filter. In this example,
the letters are in a range named CodeList. There are instructions here
for naming a range:
http://www.contextures.com/xlNames01.html

Then, enter a formula that in the first row of data, and copy down to
the last row of data. In this example, the letters are in column A, and
the data starts in row 2:

=COUNTIF(CodeList,A2)

Add a heading to the column with the new formula, then filter this
column for rows that contain a 1.
 
Back
Top