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 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
Linkedin Login
Parameters
OfNumber, ForCol, Optional RankOrder = 1, Optional CompanyNameCol = "B", Optional InSheet = "CI Calc"
Statistics
Views 451
Downloads 108
IDs
CodeID
DB ID
Requirements
Codes Required 0
Similar Codes
Similar codes
By Developer
Recent 4 by ANmarAmdeen 4
Random Codes
Random Codes 4