Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sort
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
|
|||
|
|||
You can use the Rank() function, accessing the column where you say you have
already created a formula to display the difference between the goal and the result. Say the names are in Column A, and the column displaying the differences is Column D, try this in Column E: =RANK(D2,$D$2:$D$50) And copy down as needed. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "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 | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) |