Post Views : 0

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

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.