What is the rank EQ function in Excel?

Answer 1

It is a function that will give you the ranking (largest to smallest, or smallest to largest depending if you tell it to rank descending or ascending respectively) and the EQ tells Excel to assign an equal rank if there are ties.