Group return value.

[serge]

Hi,


I have 6 groups of numbers :


1 to 7 = 1
8 to 14 = 2
15 to 21 = 3
22 to 28 = 4
29 to 35 = 5
36 to 39 = 6


Starting in column C9 I have numbers that run from 1 to 39.
and starting in column AF9 I would need a formula that return the group ID of that number.


so if in C9 I have the number 16 in AF9 it should return the group 3
if in C10 I have the number 33 in AF10 it should return the group 5
and so on, Thank you.

Serge.

 

[Fluff]

One option
=IF(C9<8,1,IF(C9<15,2,IF(C9<22,3,IF(C9<29,4,IF(C9<36,5,IF(C9<40,6,""))))))

 

[serge]

Thank you so much Fluff, that exactly what I needed, I really appreciate it.
Serge.

 

[Fluff]

Glad to help & thanks for the feedback

 

[planetpj]

Another
=INDEX({1,2,3,4,5,6},MATCH(C91,{1,8,15,22,29,36},1))