Catherine has attended:
Public Speaking with Authenticity and Credibility course
Excel Intermediate course
Repetitions of names in lists
I have a spreadsheet containing thousands of rows of data, each of which is about a committee membership role. Most people in the list are only on one committee (one role), however many are on more than one. I'd be very grateful for any advice on the simplest way to find out how many people in the list just have one committee role (ie just appear in one row) and how many people have more than one committee role, ie their name is in more than one row.
RE: Repetitions of names in lists
Hi Catherine,
Thankyou for your question to the forum.
The answer to your problem is using the UNIQUE function twice! Here's how:
=COUNTA(UNIQUE(D2:D30,,TRUE))
This gives you a count of all names (range D2 to D30) where they only appear once. (NB. the 2nd comma is entered in order to 'bypass' the 2nd argument so this is important to include).
To get a count of names appearing multiple times you need to subtract the above formula from a count of unique names:
=COUNTA(UNIQUE(D2:D30))-COUNTA(UNIQUE(D2:D30,,TRUE))
I hope this helps
Kind regards
Martin
