Hi
I have a list of numbers and want to filter out negative values?
What kind of formula would I need for that?
It looks like this. ie. want to filter out the line with -88 and -9. I tried an if function with the operator [column],"02 but couldn't get it to work
Column A
2
77
-88
454
3
-9
Solved! Go to Solution.
sorry formula tried looked like if [column A]<"0" but I didn't know how to finish
I actually just realised that after I posted!