Find if a specific number is present in a range of ranges

[Sriram Iyengar]

Hi All,

I have a range of numbers and need to find if a specific number falls in that range example below. These are the grids in the range

0 - 100
101-250
251-500
501-750
751-1500
1501-2500
2501-3500
3501-5000
5001-6500
6501+

I need to know as to in what category the below numbers fall

2584
2437
1816
2655
709
78
257
532
720
1878
4469

 

[Somendra Misra]

Hi Sriram,

See the file.

Regards,

 

[Sriram Iyengar]

Awesome !! Thanks Somendra

 

[Somendra Misra]

You are Welcome!!!

Regards,