Using Excel to rank excluding duplicates

Purpose: when there is a field containing text values, with some blanks, rank the values but exclude duplicates and blanks.

Link to example spreadsheet

Passing off

Brushed up on Passing off  (thanks Wikipedia): "The law of passing off prevents one trader from misrepresenting goods or services as being the goods and services of another, and also prevents a trader from holding out his or her goods or services as having some association or connection with another when this is not true."