Dear friends, I'm trying to write a formula that would filter data from one column based on condition entered in a cell.
This one works great with single numbers or text in a reference cell:
=IF((a2=C$3);a2;"") copied down the column
but if I try to filter all numbers greater than 2 (I eneter ">"&2 in cell c3) it doesnt work. Please help. Is it possible with if formula or should I use something else?
Thank you in advance
Bookmarks