RANK not resulting as hoped
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
|