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.CodesLogin
OfNumber, ForCol, Optional RankOrder = 1, Optional CompanyNameCol = "B", Optional InSheet = "CI Calc"
rank, nmrrank, v2021, range, continues, ranges, exclude, include, TCA, excel formula, function, replace, substitute, nmrrank_v2021