Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a worksheet with a column, user_ID, that contains a large number of user IDs

I'd like to filter it down to about a dozen IDs, but using Filter -> Custom Filter only allows me to filter by 2 IDs total.

Is there a better way to filter this column by this dozen or so IDs?

share|improve this question
custom sort or custom filter? If you go to filter - filter you can specify all the values with checkboxes – Raystafarian Jul 23 '13 at 23:37
I believe that the sentence only allows me to filter by 2 IDs total isn't clear at all. Can you please describe this better? Can you upload a photo maybe? – Math Jul 24 '13 at 1:34
up vote 19 down vote accepted

Filter -> Custom Filter only allows me to filter by 2 IDs total.

Excel's Advanced Filter can filter for as many values as you want

enter image description here

  1. Set up your criteria range. The header must be named exactly like the column where Excel should apply your filter to (data table in example)
  2. Select your whole table (A1:A11 in example)
  3. Go to: Menu Bar » Data » Filter » Advanced
  4. Select your whole criteria range including the header under Criteria range (C1:C4 in example)

enter image description here enter image description here

share|improve this answer
awesome, this worked. "advanced filter" in excel 2010. – fox Jul 24 '13 at 20:14

I discovered that if you want to do an advanced filter on "contains text", you can put a wildcard (*) at the beginning and end of the criteria text. This allows a bit of a fuzzier match. For example *Bob Smith* in C2 above could pull "Bob Smith" OR "Mr. Bob Smith" out of column A, if it existed there.

share|improve this answer
Whoops, make that (asterix)Bob Smith(asterix) for c2. The comment doesn't show the asterix I typed there, but changed the font instead. – Chuck Feb 4 at 20:25

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .