Rank of numbers between specified range
Solved/Closed
talent.anand
-
Sep 28, 2017 at 02:06 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 2, 2017 at 11:54 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 2, 2017 at 11:54 AM
Related:
- Rank of numbers between specified range
- Apple airtag range - Guide
- Excel marksheet rank formula - Guide
- Wimax frequency range - Guide
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- If function with date range - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 28, 2017 at 11:27 AM
Sep 28, 2017 at 11:27 AM
Hi Talent.anand,
Create a separate table for all your ranks and then use VLOOKUP to pull the rank for a specific rank.
Example:
Best regards,
Trowa
Create a separate table for all your ranks and then use VLOOKUP to pull the rank for a specific rank.
Example:
Best regards,
Trowa
Sep 28, 2017 at 10:53 PM
It's excellent, Thanks for quick reply and help. I am fully aware of vlookup but never thought of such a wonderful way to use it,
Thanks a lot for your nice suggestion and solution. I appreciate your timely help.
Oct 2, 2017 at 11:54 AM