Rank of numbers between specified range
Solved/Closed
talent.anand
-
28 Sep 2017 à 02:06
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 2 Oct 2017 à 11:54
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 2 Oct 2017 à 11:54
Related:
- Rank of numbers between specified range
- How to increase wifi range - Guide
- Excel vba range find - Guide
- Wimax range - Guide
- Excel vba copy range to another workbook - 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 named ranges. ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
28 Sep 2017 à 11:27
28 Sep 2017 à 11:27
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
28 Sep 2017 à 22:53
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.
2 Oct 2017 à 11:54