Thread: Grouping
View Single Post
  #1   Report Post  
KenL
 
Posts: n/a
Default 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