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.
Google-sheets – How to count unique text in multiple column with mixture of number and text
google sheetsgoogle-sheets-arrayformula
Related Solutions
Assuming your dates are in A1:A30, the following array formula worked for me:
=ArrayFormula(COUNTUNIQUE(TEXT(A1:A30,"yyyymmdd")))
I know this is an old topic, but for the number of unique articles, this might work:
=ArrayFormula(counta(unique(filter(A2:A&B2:B, len(A2:A&B2:B)))))
I also tried to work out some formulas for the other questions:
Hope this helps ?
Related Topic
- Google Sheets – Count Non-Blanks with Unique Values in Another Column
- Google Sheets – How to Count Occurrences of a Number in a Column
- Google-sheets – Google Sheets Count Unique value with multiple criteria
- Google-sheets – Count the unique values in a Column based on criteria in 2 different columns
- Google Sheets Formulas – Count Unique Values Appearing More Than X Times
- Google-sheets – way to count unique numbers and count unique text+numbers
- Google Sheets – Count Unique Values by Group Only If Not Counted in Previous Group
- Google Sheets – Count Unique Values in Second Column Corresponding to Unique Value in First Column
Best Answer
to count unique in A column:
to count unique in A and D column via 1 formula:
to count unique in A and D per column:
to count unique text in A and D: