Classify grups
 

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.

Classify grups
 

Have a look in Excel help for the function VLOOKUP.
--
David Biddulph

"Tiiii" wrote in message
...
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.

Classify grups
 

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


"Tiiii" wrote in message
...
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.