Excel unique function

Copper Contributor


i want to count the numbers of unique entries in a row. On the Internet i've seen the use of =COUNTA(UNIQUE(...)) and tried it, but i do get 1 as a result everytime. If I only use the unique-function i do get "#NAME". Also the unique function is not in the list of functions. Do I have a "wrong" Version? I tried it on other PC's with other Versions but it still won't work.

How can I fix it? Or maybe there is a workaround.

6 Replies


UNIQUE function

Only works on, Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones.


Count unique values

To count unique values in a set of data, you can use the UNIQUE function together with the COUNTA function. In the example shown, the formula in F5 is:


more infos in the upper link




I now downloaded this (https://www.microsoft.com/de-de/microsoft-365/try) as a testversion for pc and it still does not work.
I did not send you such an address.
You may need to run updates via File | Account | Update options.


thats rigth. but you didn't send me a downloadlink either

Since I just downloaded and installed Microsoft 365 as a testversion everything is perfectly uptodate