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-fu...
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.
- Since I just downloaded and installed Microsoft 365 as a testversion everything is perfectly uptodate
- I did not send you such an address.
thats rigth. but you didn't send me a downloadlink either
