Purpose: when there is a field containing text values, with some blanks, rank the values but exclude duplicates and blanks.
Link to example spreadsheet
A record of Michael Veale's Continuing Professional Development. Further details before Oct 2010 are on a CIMA CPD tool.