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.

Grouping data
 

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



"Darshan" wrote:

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.

Grouping data
 

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/2001...troduction.pdf



Regards,
Ryan--




--
RyGuy


"Mike H" wrote:

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



"Darshan" wrote:

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.