Forum Discussion

Tommy2355's avatar
Tommy2355
Copper Contributor
Sep 15, 2022

Does Excel have Count Distinct options

I know the ability to countdistinct numbers exists in Power Query and other tools but can it be done in Excel? I only work in excel and have not had good luck learning Power Query.  I am just an old ...
  • Harun24HR's avatar
    Sep 15, 2022

    Tommy2355 Its pretty easier in Excel-365.

    =COUNTA(UNIQUE(A1:A9))

     

     

Resources