unique distinct counts.

It might help if you specified the expected results based on the sample data.

For ex. what do you mean by unique initials - the different initials used found under that username or the number of different people where initial may differentiate between two with the same surname ?

Assuming you want counts of unique titles, unique initials and unique surname then:

Please Login or Register  to view this content.

Note the above must be entered with CTRL + SHIFT + ENTER (not just Enter as per a "normal" formula)

copied across matrix C5:E9