If:
column A
a123
b345
c567
1234
1245
column D
a123
b234
c223
4567
7689
How to put the formula to count the number of unique text in both column A and D? So that there is 5 count of unique text in both column.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityIf:
column A
a123
b345
c567
1234
1245
column D
a123
b234
c223
4567
7689
How to put the formula to count the number of unique text in both column A and D? So that there is 5 count of unique text in both column.
to count unique in A column:
=COUNTUNIQUE(A1:A)
to count unique in A and D column via 1 formula:
=COUNTUNIQUE({A1:A; D1:D})
=COUNTUNIQUE({A1:A\ D1:D})
to count unique in A and D per column:
={COUNTUNIQUE(A1:A), "", "", COUNTUNIQUE(D1:D)}
={COUNTUNIQUE(A1:A); ""; ""; COUNTUNIQUE(D1:D)}
to count unique text in A and D:
=ARRAYFORMULA(COUNTA(IF(ISTEXT(UNIQUE({A1:A;D1:D})), 1, )))
=ARRAYFORMULA(COUNTA(IF(ISTEXT(UNIQUE({A1:A;D1:D})), 1, )))
– user0
Feb 28 '19 at 16:52