Grouping data

D

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.
 
M

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
 
Top