[SOLVED] Is there a way to filter two columns which either of the value in column is greater than 20?

Issue

This Content is from Stack Overflow. Question asked by anonymous

I have a TSV/excel flle with numeric data. I want to filter out all the row from which either column A or B should have values greater than 15.

I tried to get the sum of the column in an additional column and filter, but it doesn’t make sense if cells contains 7 and 8. also average of the column also not working if the cells has 20 and 5

Data i have

input

Result i need

Result i need

Im very noobie to excel,Please help

Thanks in advance



Solution

The easiest way is to create a helper column, containing following formula: =OR(A2>=20,B2>=20). (Start at cell C2 and drag further down)
Filtering on this helper column (value TRUE) will result in this screenshot:

enter image description here


This Question was asked in StackOverflow by anonymous and Answered by Dominique It is licensed under the terms of CC BY-SA 2.5. - CC BY-SA 3.0. - CC BY-SA 4.0.

people found this article helpful. What about you?