The RANK function returns the rank of a number in a list
of numbers.
1.
If the third argument is omitted (or 0), Excel ranks the
largest number first, second largest number second, etc
Note: when we
drag the RANK function down, the absolute reference ($A$1:$A$9) stays the same, while the relative reference (A1) changes to
A2, A3, A4, etc.
No comments:
Post a Comment