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