Numbers formula to count names but count duplicate names as one

I am wanting a formula that can count how many names I have in my column but I want the duplicates not to be counted or the two entries are counted as 1.


So in this example I would want the formula to tell me I have 4 names. Is this possible?

MacBook Pro 15″

Posted on Feb 14, 2025 7:39 AM

Reply
3 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers formula to count names but count duplicate names as one

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.