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

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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