Counting individual names from a list

Hi,

Please refer to the sample spread sheet attached.
I'm trying to count the number of people in a list, however duplicated names do not add to the total.

Thanks, Paul

Hi there, you can use this:

Formula:

Please Login or Register  to view this content.

.
Or if you prefer .. paste this Function into a Routine Module :

Please Login or Register  to view this content.

Then in a cell enter the formula: =CountUniqueValues(C5:C16)

.
This formula will also count the unique names:

Please Login or Register  to view this content.

Type the formula in, then press CTRL / SHIFT / ENTER

Originally Posted by Skiptomylou

Hi there, you can use this:

Formula:

Please Login or Register  to view this content.

Thanks for that. This seems the easiest, as I don't have Macros enabled in the original work book (for a reason).
Only snag, if I include blank rows (to allow for extra names in the future), it comes up with an error. I don't really want to edit the formula every time someone is added.
Any easy solution?

Cheers, Paul

Try:

=SUMPRODUCT(1/COUNTIF(C5:C16,C5:C16&""))-(COUNTBLANK(C5:C16)>0)

Beat me to it