identify distinct names in filtered list

[ajm]

hi all, i am trying to work out a way of counting unique/distinct names in a list. Unfiltered is straightforward. In each row: countif($a$2:$a2,$a2). I need to be able to have a formula that will also operate on the same data when it is filtered. I aim to be able to identify distinct names by year as well as overall.

 

[footoo]

https://www.google.com/search?q=exc....69i57j0l5.29711j0j8&sourceid=chrome&ie=UTF-8

 

[ajm]

thanks footoo. I have seen this one before. I am actually trying to mark each record or row of my list in the last column, as opposed to counting the total of all rows.

 

[ajm]

the aim is to then use the tabular data in a pivot. the pivot table will be filtered for distinct names in a particular year, per category, etc