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 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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.