What do you mean by ".2,.75, anmd .5 return in col c. 0-1"? If you mean
that column c should contain 3 corresponding to 0-1, then look at Help
for COUNTIF()

Jerry

KenL wrote:

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