» Ranking Numbers in a Dynamic List
Range A4:A8 contains a list of numbers that is frequently changed by the addition or removal of numbers. Consequently, the current rank of each number is constantly changing.
We want to create a formula that will automatically update the rankings in column B upon the addition or removal of numbers in column A.
Use the RANK, OFFSET, and COUNTA functions in the following formula:
|Screenshot // Ranking Numbers in a Dynamic List|