Classify grups

[Tiiii]

hi,

How do I create a column that classify grups, like if i have one column with
numbers from 0 to 2000 and I want another column that gives me a number like
1 if the other number is from 0 th 300, 2 if the number is from 301 to 500, 3
if the number is from 501 to 1000, 4 if the number is from 1001 to 1500 and 5
if the number is bigger than 1501.

 

[David Biddulph]

Have a look in Excel help for the function VLOOKUP.

 

[MartinW]

Hi Tiiii,

With your numbers in A1 down, try this in B1
=LOOKUP(A1,{0,301,501,1001,1501},{1,2,3,4,5})
and drag down as far as needed.

HTH
Martin