Forum Discussion
Filter with numbers and symbols
Thanks for your reply.
Sorry I was not clear enough. I want to be able to filter from high to low. Also I was talking about column F (WA). So entries like 40- are not relevant. If you mean this symbol by blank: · Then you are correct. That is the first data entry. The other 3 are indeed: numbers, number ranges (x-x), number+.
Also maybe I should add. That formula looks very complicated to me. Can I just copy paste that in the 2nd cell of the new inserted column G?
Kalthof So I don't even know what filter high to low would necessarily look like, but with both a MIN WA and MAX WA column you have a lot of options (e.g. sort MAX WA column 1st and MIN WA column 2nd or is it a maximum minimum value or max value then name ...)
As for the formulas the [WA] needs to be replaced with either [@WA] if that is a table or F2 if not
As for what the formulas do here is the Min explained:
Min WA:
=IFS( F2="","", 'if blank return blank
ISNUMBER(F2,F2, 'if a number return the number
RIGHT(F2)="+",--LEFT(F2,LEN(F2)-1), 'if right character is "+" then return all but that last character
RIGHT(F2)="-",0, 'if right character is "-" then return 0
1,--LEFT(F2,FIND("-",F2)-1)) 'all other cases return what is before the "-"