Reputation: 1
I want to use the filter option and filter data based on two columns. The filter should throw results of only those rows where column 1 value < column 2 value.
Tried using conditional format option in the Filter (drop down at top right) option but something does not seem to be correct. Can someone please help with the correct way to do this?
Thanks.
Upvotes: 0
Views: 1771
Reputation: 13494
You may refer with these documentation and thread. I've tried replicating your issue using the formula: =A2<B2
.
Here is my sheet:
Filtered using the formula: =A2<B2
:
Output:
Hope this helps!
Upvotes: 1