Hello,

Is there a way to shift the range for the rank function according to
criteria?

Example: Rank a given number within a range of other cells that are
alike. For example, rank all numbers where the value in column A is
XYZ. The formula will need to be dynamic so that once it hits row 5, it
would now rank everything where the value in column A is ABC.
Essentially, somehow the range needs to examine a list of data and then
identify all circumstances that are alike, and return a cell location.
It may make things easier to know that my data is in sequential order,
ie column A sorted least to greatest. However, if this were to change,
the ranking function must still work.

There will always be 12 instances of the value in column A. So, 12
XYZs, 12 ABCs, etc. Maybe it would be easier to return the first
greatest value of all XYZs, then the second, etc?

Example of how the data may look:
A......B......C(The rank that should be returned)
XYZ...5......3
XYZ...2......2
XYZ...7......4
XYZ...1......1
ABC..1......1
ABC..8......3
ABC..3......2
123...11.....2
123...20.....3
123...5.......1

Thanks for your help, and congratulations if you can understand what Im
trying to say;)
-S