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
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:
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.