Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

up vote 5 down vote accepted

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

Excel's Special Filter can actually filter for as many values as you want.

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

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.