identify distinct names in filtered list

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
1,748
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.
 
Last edited:

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
1,748
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

Well-known Member
Joined
Feb 5, 2003
Messages
1,748
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
 

Watch MrExcel Video

Forum statistics

Threads
1,095,750
Messages
5,446,271
Members
405,393
Latest member
sully361

This Week's Hot Topics

Top