RANK IF Descending

[PetervanF]

Good day,

currently using following formula for an ascending rank if solution which works fine.

=SUMPRODUCT(--(I$11:I$11000=I11)*(AA11<AA$11:AA$11000))+1

My thread: Is there also a similar formula for a descending Rank IF solution?

Appreciate any feedback!

Best regards,
Peter

 

[PetervanF]

It seems that the formula is not completely projected:
=SUMPRODUCT(--(I$11:I$11000=I11)
*(AA11<AA$11:AA$11000))+1

 

[PetervanF]

=sumproduct(--(i$11:i$11000=i11)
*(aa11<aa$11:aa$11000))+1