Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 sheet with a bunch of data. I know it is easy to filter rows so that only data in a given column shows. I can filter by surname only for example, that's easy.

Is there a way to filter with what would be in programming, an OR? So, say I want to find all the rows with "blue" in columns C, D, E or F.

Am I going to need a macro for this?

share|improve this question
up vote 1 down vote accepted

Here is some easy work-around:

  1. Go to the empty column G.
  2. Input the following function: =COUNTIF(C2:F2;"blue") and copy for entire column.
  3. Rows containing values you're looking for ("blue") will be counted.
  4. Use filter on G column to hide all "0" ("0" means no "blue" value in C, D, E and F columns).
share|improve this answer
Perfect, thankyou – Martin Heathcote Sep 18 '12 at 14:11

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.