Forum Discussion
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...
=COUNTA(UNIQUE(FILTER(A2:A13,A2:A13<>"")))=TEXTJOIN(",",TRUE,UNIQUE(FILTER(A2:A13,A2:A13<>"")))
In A14:
=COUNT(UNIQUE(FILTER(A2:A13, A2:A13<>"")))
Fill to the right to B14.
In A15:
=TEXTJOIN(", ", TRUE, UNIQUE(FILTER(A2:A13, A2:A13<>"")))
Fill to the right to B15.