SOLVED

Iron Contributor

# 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 A14== 2, B14==3,

I tried to use comb of COUNTIF and UNIQUE, but seems something is broken, or my logic seems not correct.

Secondly, in A15,B15 want to print the unique values( so A15== 0,1 ; B15 == 0,1,2)

I can use remove duplicated from data tab, but I don't want that as I need to use these cells output(A14/B14) further, without modifying the columns A and B, which this option of remove-duplicate does..

Br,

Anupam

2 Replies
best response confirmed by anupambit1797 (Iron Contributor)
Solution

# Re: UNIQUE Function not working

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

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

# Re: UNIQUE Function not working

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.

1 best response

Accepted Solutions
best response confirmed by anupambit1797 (Iron Contributor)
Solution

# Re: UNIQUE Function not working

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

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