Tom’s Tutorials For Excel: Ranking With Conditional Omission

Tom’s Tutorials For Excel: Ranking With Conditional Omission

Here’s an example of ranking a list while omitting an item for consideration. In blue cell E2 is the name of an employee to eliminate from consideration in the ranking process.

The formula in cell C5 and copied down to cell C20 is
=IF(A5<>$E$2,SUMPRODUCT(($A$5:$A$20<>"")+0,(B5<$B$5:$B$20)+0)+1,"")