Grouping data

[Darshan]

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.

 

[Mike H]

If ive understood correctly, try this.

make a table like below and in my case in H1 to I3

Col H Column I
-1000.00% loss
1.00% normal
28.00% Above normal

Then with your percentages of profit/loss in column A put this in B1 and
drag down:-

=VLOOKUP(A1,$H$1:$I$3,2)

Thresholds can be altered by altering the table but it should be left sorted
ascending as it is now.

Mike

 

[ryguy7272]

I think you could try this:
http://peltiertech.com/Excel/Pivots/pivottables.htm

http://www.cpearson.com/excel/pivots.htm

http://it.fuqua.duke.edu/public/2001PivotTableIntroduction.pdf



Regards,
Ryan--