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

This question is not yet answered, be the first one who answer using the comment. Later the confirmed answer will be published as the solution.

This Question and Answer are collected from stackoverflow and tested by JTuto community, 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?