Tanveer Sure
Tanveer Sure

Reputation: 1

Filter google sheet based on two columns

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

Answers (1)

abielita
abielita

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:

enter image description here

Filtered using the formula: =A2<B2:

enter image description here

Output:

enter image description here

Hope this helps!

Upvotes: 1

Related Questions