Thread: Grouping data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Darshan Darshan is offline
external usenet poster
 
Posts: 12
Default Grouping data

Hi

I have a column with various percentages I what to group them according to
-100% to 0% = Loss
1% to 27% = Normal
28% to 100% = Above Normal

how can i do this. it would be helpful if I can change the percentage ranges
and add new ranges in the future.