Thursday, November 29, 2012

Excel Formula - Rank

Rank a specific number size wise against other numbers in a list a data.
Formula: Rank(number; ref; [order])
Options for [Order] : 0 (descending), 1 (ascending)
Example :