Rank with Exclusion

Rank with Exclusion
Recently I stumbled upon a problem of ranking observations with exclusion, i.e., not including all of them in the rank. In Excel prior to 2010 you would normally use function =RANK(), in all later versions there are also functions =RANK.EQ() and =RANK.AVG(). They differ only in a way of assigning a rank to observations which ...