Forum Discussion

anupambit1797's avatar
anupambit1797
Steel Contributor
Jul 02, 2024
Solved

UNIQUE Function not working

Dear Experts,                      I have a scenario , as below:- Column A and Column B has values as below:- In Cells, A14,B14 , I want the Count of the UNIQUE values of those columns, so A...
BI & Data Analysis
excel
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Jul 02, 2024

    anupambit1797 

     

    =COUNTA(UNIQUE(FILTER(A2:A13,A2:A13<>"")))

     

    =TEXTJOIN(",",TRUE,UNIQUE(FILTER(A2:A13,A2:A13<>"")))

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jul 02, 2024

anupambit1797 

 

=COUNTA(UNIQUE(FILTER(A2:A13,A2:A13<>"")))

 

=TEXTJOIN(",",TRUE,UNIQUE(FILTER(A2:A13,A2:A13<>"")))

 

Resources