Good Morning every one.
This is my first question in the forum. Please excuse me if i did anything wrong
I am new to Microsoft 365.
I want to filter the data basing on the cell value. where i will type >90.12%, <89% likewise. Then the FILTERED data should be extracted.
Example
=FILTER($B$7:$F$80,$E$7:$E$80,$A$1)
When I put >90.12% or <89% so on in A1 cell I want to get the FILTERED data basing on the value in AC1 cell. I am unable to put < or > in the A1 cell.
But I am getting data if i hardcode < or > in my formula
like this one
=FILTER($B$7:$F$80,$E$7:$E$80<A1).
I hope i will get early reply. Thank you.
Bookmarks