Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping data | Excel Discussion (Misc queries) | |||
Grouping Data | Excel Worksheet Functions | |||
grouping data | Excel Worksheet Functions | |||
Re; Grouping Data? | Excel Worksheet Functions | |||
data grouping | Excel Worksheet Functions |