Grouping
I have a sheet that looks like this
Col A Col B
..2 0-1
2.3 1.01-2.5
1.4 2.51-4.5
4.3 5-99
4.1
..75
..5
I want to the sheet to return col c so that I can group the values that are
represented in col, b. so that .2,.75, anmd .5 return in col c. 0-1.
any ideas?
Thanks
|