Thread: Classify grups
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tiiii Tiiii is offline
external usenet poster
 
Posts: 1
Default 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.