Forum Discussion

blablablubb's avatar
blablablubb
Copper Contributor
Mar 02, 2023

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.

excel
Formulas and Functions

6 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Mar 02, 2023

    blablablubb 

    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:

    =COUNTA(UNIQUE(B5:B16))

    more infos in the upper link

     

     

     

    • blablablubb's avatar
      blablablubb
      Copper Contributor
      Mar 02, 2023
      I now downloaded this (https://www.microsoft.com/de-de/microsoft-365/try) as a testversion for pc and it still does not work.
      • Patrick2788's avatar
        Patrick2788
        Silver Contributor
        Mar 02, 2023
        You may need to run updates via File | Account | Update options.

Resources