Forum Discussion
Excel unique function
Hey,
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.
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.
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:
=COUNTA(UNIQUE(B5:B16))
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.
- You may need to run updates via File | Account | Update options.
