Hi,

What do you want it to do?

The first part
=RANK(G6,G$6:G$130)
will rank G6 in the range G6 - G30 and works fine. If you drag it down it
will rank G7 etc.

The second part is confusing
+COUNTIF(G$6:G6, G6)-1
As displayed it wil count how often the value in G6 appears in the range
G6-G6 and subtract 1 so it will always evaluate as zero.
If you drag it down it becomes
+COUNTIF(G$6:G7, G7)-1
at this point it is evaluating a 2 cell range for whatever is in G7
What do you want it to do?

Mike

" wrote:

Can anyone figure out why this formula would not be working (all cell
formatting is in tact):

RANK(G6,G$6:G$130)+COUNTIF(G$6:G6, G6)-1

Thanks in advance,

BK