Ranks a number among set of numbers.
This is part of huge tool, we needed to substitute of Excel sheet function RANK, because RANK actually does not accept range that is not continues.
Means if you list of numbers are in two separate ranges, RANK will not help.
This Custom-made Excel function will exclude cells having certain value in certain column.
Similar to Rank, you can pass the order of rank
Access to code is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Bold.Codes
Login
OfNumber, ForCol, Optional RankOrder = 1, Optional CompanyNameCol = "B", Optional InSheet = "CI Calc"
Views 57
Downloads 18
VBA-Excel
Math
ANmarAmdeen
925
Attachments
Revisions
v1.0
Thursday
September
23
2021
Tags
rank, nmrrank, v2021, range, continues, ranges, exclude, include, TCA, excel formula, function, replace, substitute, nmrrank_v2021
