Google-spreadsheet has a built in function (COUNTUNIQUE) that will count the unique entries in a range. Excel has had a long standing SUMPRODUCT(1/COUNTIF(...)) equivalent. [count-unique] is for the complex application of these functions/formulas with criteria and range adjustment.
Questions tagged [count-unique]
23 questions
0
votes
2 answers
How to use Excel or Google Sheets COUNTUNIQUEIFS where the unique cell meets two conditions in same criteria column
I have a call log that I want to determine the number of answered and unanswered unique callers. However, if a caller has both statuses answered and answered, I want it to count as answered, since someone talked to that caller at some point. I…
Les
- 330
- 5
- 15
0
votes
1 answer
Counting unique and group by from multiple spreadsheet
I have problem in processing my data. I need to query unique ID from multiple sheets and group by specific criteria.
Here's the google sheet example so you can see the…
ettapi
- 51
- 4
0
votes
2 answers
How to COUNTUNIQUE across multiple sheets in single workbook
I need to count the number of unique entries in a column across multiple sheets in a single workbook. Not just the unique entries in one of the sheets, but comparing all sheets in the workbook for unique entries. I understand how to count unique…
user5176291
- 167
- 2
- 14
0
votes
1 answer
Add Partial Text Match as Criteria to a Count Unique Formula
I've been trying to add a partial text match as a criteria to the formula below, but with no success so far:
=SUM(--(FREQUENCY(IF(Sales[ClientID]=A21;IF(Sales[Operation]="Sale*";Sale[InvoiceNumber]));Sale[InvoiceNumber])>0))
The piece…
onit
- 2,275
- 11
- 25
0
votes
3 answers
VBA count the number of unique values
I looked into the forum and I cannot really find the right answer to my problem. I have a list which looks like this:
ID ID2
SS_ID 1 T1
SS_ID 1 T2
SS_ID 1 T2
SS_ID 1 …
David Morocutti
- 1
- 1
- 4
0
votes
3 answers
Counting unique occurrences
I am trying the count the number of unique sensors (column 1) that are present by visit duration (column 2). Here is a small portion of the data:
Sensor ID Implant duration
13113 1
13113 1
13113 1
13144 1
13144 1
13144 2
13144 …
BillyBoy
- 111
- 7
-1
votes
1 answer
How can I countunique with countifs?
I want to use count if, only if a value is unique.
I've tried a number of syntaxes starting with countif and countunique, but they all failed so far.
Here's one I've tried:
=COUNTIFS(COUNTUNIQUE('Copy of IMP CRM (for analysis)'!F:F),'Copy of IMP…
ASE
- 145
- 1
- 1
- 8
-2
votes
1 answer
count repeated date as one in excel
i want to count working days in a week by mentioned dates only like in picture only 4 working days will be considered in filtered data "year, month, and Week are derived by induction date column.Example
