View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pooja pooja is offline
external usenet poster
 
Posts: 9
Default Urgent Request. please help

Hello
This is kind of urgent, as I have this request from my manager.
What I have is a excel sheet with numbers raning from $1 to $million dollars.
and we have to bucket them up and label them A, B , C .....
ex.. Range 1-- any $ amount between (1 and 10,000)--is A.
Range 2-- any $ amount between (10,000 and 100,000)--is B.
Range 3-- any $ amount between (100,000 and 1million)--is C
Range 4-- any $ amount between (1million and 5million)--is D
Range 5-- any $ amount over 5million--is E.

Can you please help me with this. I tried using the help section, but wan't
able to find any useful info.

Thanks a lot for your help.