ExcelNewbie2020
Active Member
- Joined
- Dec 3, 2020
- Messages
- 289
- Office Version
- 365
- Platform
- Windows
Experts,
Please see table below;
Is there any excel function that will rank the values based on the first data inputted?
on the above table rank # 1 goes to Name3 because i inputted the value 200 1st, rank #2 is Name7 because i inputted 1000 2nd and so on..
I am looking for a function that once i input a value, the rank/sequence will update automatically. Thank you very much..
Please see table below;
Value | Rank | |
Name 1 | 10 | 5 |
Name 2 | ||
Name 3 | 200 | 1 |
Name 4 | ||
Name 5 | ||
Name 6 | ||
Name 7 | 1000 | 2 |
Name 8 | ||
Name 9 | ||
Name 10 | 500 | 3 |
Is there any excel function that will rank the values based on the first data inputted?
on the above table rank # 1 goes to Name3 because i inputted the value 200 1st, rank #2 is Name7 because i inputted 1000 2nd and so on..
I am looking for a function that once i input a value, the rank/sequence will update automatically. Thank you very much..