Excel Formula

Question

Hi there,

With the the example:

The values "Bradley", "Doyle", "Doyle", "Doyle" the result is two unique values — "Bradley" and "Doyle".

What would the formula be to get the result 2 in a cell?

Thanks,

Aleisha

Answer 1

Hi AleishaB,
Thanks for your post in Microsoft Community.

If your cells A1 through A4 contain the values "Bradley", "Doyle", "Doyle", and "Doyle" respectively, you can try this formula:

=COUNTA(UNIQUE(A1:A4))

This formula will count the unique values in the range A1:A4. In this case, it should return the result 2, as there are two unique names: "Bradley" and "Doyle".

I hope the information above is helpful to you!

Best Regards, 
Thomas C - MSFT | Microsoft Community Support Specialist

Answer 2

Given that this is a new question, in order to better maintain the order of the community, I will split and move your new question to a new thread. You can click on this link to access it: CountA formula with Filter Feature - Microsoft Community. I will answer your question in the new thread.

Thomas

Answer 3

I'm glad your issue was resolved. If my previous explanations were helpful to you, please select 'Yes' under the response that assisted you.

This will highlight the response and make it easier for other users encountering the same query to find this thread through search engines. Thank you for your cooperation.

Have a nice day!

Thomas

Answer 4

Hello Thomas,

Works beautifully :)

Appreciate your help!

Aleisha