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
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