You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Jeff" wrote in message
...
To: Bob & T.

Thank you very much! Both do the trick. I'm not sure which is better but I
like that T.,s is shorter so I'm going with that.

Thanks again, Jeff

"T. Valko" wrote:

Try this:

=IF(C10=0,"",RANK(C10,$C$10:$IV$10,1)+COUNTIF($C$1 0:C10,C10)-1)

--
Biff
Microsoft Excel MVP


"Jeff" wrote in message
...
I guess I misunderstand how RANK works...

The following is pasted across row C11:IV10

"=IF(C10=0,"",COUNT($C$10:$IV$10)-(RANK(C10,$C$10:$IV$10)+COUNTIF($C$10:C10,C10)-1)+1)"

Value in BO10 and CD10 are the same (201) which is the highest in that
row...
but BO11 ranks BO10 253 and CD11 ranks CD10 252. I need it to be the
other
way around. In other words, rank duplicate values higher the further
(to
the
right) across the row they are.

Thank you, Jeff