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.
|