DAlmond123
New Member
- Joined
- Mar 2, 2021
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Hi All,
I have just recently discovered this forum after attempting to self resolve a ranking issue I have with Microsoft Excel.
I wanted to know if there was a way to rank values by column name?
For example, if I have entered the values below, is there a way the values in the row can be ranked by the name of the column as shown in the Desired Output column?
Thanks!
I have just recently discovered this forum after attempting to self resolve a ranking issue I have with Microsoft Excel.
I wanted to know if there was a way to rank values by column name?
For example, if I have entered the values below, is there a way the values in the row can be ranked by the name of the column as shown in the Desired Output column?
Test 1 | Test 2 | Desired Output | |
Value 1 | 100 | 98 | Test 1 |
Value 2 | 90 | 98 | Test 2 |
Thanks!