how do i get an unduplicated count when my cells are names

B

Brenda

My staff use Excel to keep a database of people who come to us for service.
Every 90 days the person can use our service again. At the end of the year I
want to know how many people (unduplicated) used our service. How do I do
that?
Thank you.
 
G

Gord Dibben

Enter this formula in cell below your list of names.

=SUBTOTAL(3,range) where range is your range of names including
duplicates.

Use Advanced Filter to return just the unique names filtered in place.

The subtotal will count filtered names.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top