Filter google sheet based on two columns

Question

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.

Answer 1

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!