Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting
I have created a chart in order to track individual results of a few teams.
This chart lists two different types of numberical goals and then their actual result. I have already created a formula to display the difference between their goal and actual result. Because I have this chart set up listing names in a specific order, I dont want to sort ascending or descending to visually show the ranking order. Is there a way to add another column that would auto fill in a nbr listing their ranking order? For example, by Tim's name, he would have a 1 because he had the largest difference between his goal and actual result. If not, do you have any suggestions on a different approach? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting
Check out the Large function.
=Large(Rng,1) returns the largest value You could use Row(A1) instead of 1, and fill down to get these values descending, or with an Offset formula return the players names. Small(Rng,1) does the reverse. Regards Robert McCurdy "TK" wrote in message ... I have created a chart in order to track individual results of a few teams. This chart lists two different types of numberical goals and then their actual result. I have already created a formula to display the difference between their goal and actual result. Because I have this chart set up listing names in a specific order, I dont want to sort ascending or descending to visually show the ranking order. Is there a way to add another column that would auto fill in a nbr listing their ranking order? For example, by Tim's name, he would have a 1 because he had the largest difference between his goal and actual result. If not, do you have any suggestions on a different approach? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting
You might consider using a pivot table and just sort by the "score".
-- steveB Remove "AYN" from email to respond "TK" wrote in message ... I have created a chart in order to track individual results of a few teams. This chart lists two different types of numberical goals and then their actual result. I have already created a formula to display the difference between their goal and actual result. Because I have this chart set up listing names in a specific order, I dont want to sort ascending or descending to visually show the ranking order. Is there a way to add another column that would auto fill in a nbr listing their ranking order? For example, by Tim's name, he would have a 1 because he had the largest difference between his goal and actual result. If not, do you have any suggestions on a different approach? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming |