Mar 02 2023 01:28 AM
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.
Mar 02 2023 01:45 AM
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
Mar 02 2023 02:19 AM
Mar 02 2023 06:48 AM
Mar 02 2023 08:20 AM
thats rigth. but you didn't send me a downloadlink either
Mar 02 2023 08:26 AM