Stack Overflow
Stack Overflow

Questions tagged [count-unique]

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.

23 questions
3
votes
2 answers

How to use COUNTUNIQUE function within ArrayFormula and get a range result?

I have tried to use a COUNTUNIQUE function within ArrayFormula in cell 'A2' to get a result in the range like a column B that I've set a function cell by cell. But it returns only a single value. This is my formula in cell…
Nhong
  • 99
  • 3
  • 12
1
vote
1 answer

Need to count unique but not count 43 and 43W as two different instances using Google Sheets Formulas

In the table below I am trying to get a COUNTUNIQUE formula working with INDIRECT("{RANGE}") that would show 3 unique numbers. Basically 43W and 43 need to reflect the same number. I need to do this without using a staging sheet, so basically a…
Random206
  • 757
  • 6
  • 19
1
vote
2 answers

Count unique values over two columns per group

I have a data frame Segments with a company identifier gvkey, year Year, and two columns with an indicator of the industry the company operates in SICS1 and SICS2. I would like to aggregate the data as such that I receive the count of unique…
HlmlVrlrn
  • 15
  • 4
1
vote
2 answers

Google Sheets Count Unique Dates based upon a criteria in different columns

I am trying to find a formula that will give me the count of unique dates a persons' name appears in one of two different columns and/or both columns. I have a set of data where a person's name may show up in a "driver" column or a "helper" column,…
Shaun Christian
  • 35
  • 3
1
vote
2 answers

How to combine COUNTUNIQUE and ARRAYFORMULA in a dynamic range of two or three ... or n rows

My question is very similar to this one but instead of counting unique occurrences row by row I would like to do it in a range formed by 2 rows or 3 three rows... or n rows (i.e. several rows and several columns). Here's a Google Spreadsheet…
zagalico
  • 35
  • 4
1
vote
1 answer

How to use COUNTUNIQUEIFS in Goole sheets with an OR condition where a cell can meets two conditions

I'm trying to find the count of unique rows that meet multiple criteria in sheets. Data is like this: ID |TYPE 1 |T1;T2;T3 2 |T1;T7 3 |T2;T3 4 |T6 I want a count of IDs where type is either T1 or T2. The right answer is 3 (ids 1,2 and 3 have…
Chris Rosendin
  • 305
  • 2
  • 14
1
vote
1 answer

How would I find the Unique Entries using the COUNT Formula?

I am looking to find the Total Number of users opted into certain campaigns (Columns G-J). I'm not sure if I am using the correct form of the Count/CountUnique/CountIf formula when calculating the amount. I've tried the CountUnique for 1 of the…
Luis
  • 75
  • 1
  • 5
1
vote
1 answer

ARRAYFORMULA but only untill EMPTY cells in row - doesn't work

I'm trying to copy from one tab to another with ARRAYFORMULA. It works. but it does copy all empty cells in a row too. I don't want that. Here is my code: ={"Elevplan - Prosa (" & TÆLV('Formularsvar 1'!C2:C) & "/" & COUNTUNIQUE('Formularsvar…
Allan Bech
  • 391
  • 1
  • 6
1
vote
2 answers

Counting number of distinct people successfully contacted in a date range Excel

Good Afternoon, I have a large data table which contains accounts of attempts to contact clients. Each entry is marked with: a. The name of the client b. The date contact was attempted c. Whether the contact attempt was successful (S) or not…
Dustin Burns
  • 307
  • 4
  • 13
1
vote
1 answer

Count unique values using countifs?

I'm trying to create a gift table. Here is some sample data: Gift Donor ID $1 100 $1 151 $2 100 $2 186 $2 124 $4 124 $4 178 $4 162 $5 100 $5 158 In column A I've written a formula that counts the…
Michael Harris
  • 23
  • 1
  • 5
0
votes
1 answer

Need to know how many counts each unique name has in an excel

I got an excel with data that shows every client and how many times has downloaded a certain product. Some clients have downloaded multiple products separated by comma. I would like to find, which product has the most downloads and how i ll sort em…
nkow
  • 1
  • 1
0
votes
1 answer

Postgresql unique count satisfying two conditions

I am relatively new programmer. I am trying to create a left join with count of unique rows in a specific column. with normal count it is working fine, nut with unique it is failing. count(case when x.priorities = 112 then 1 end) as Urgent. it is…
SANAL RAJ
  • 19
  • 1
0
votes
2 answers

Find unique count using query function in google sheets

I have 3 columns: date, user & total with multiple rows for the same date. I am using the query function to derive date wise total and unique count of the names but i am not able to count the unique occurence of values in user column. Please refer…
Crazy8
  • 11
  • 3
0
votes
2 answers

How to apply unique count among all the months in PowerBI table visual?

Hi everyone, I have a table visual as shown in the screenshot above. The Total number of new students shown in the table visual is 210. However, when I manually sum the value, i.e. 20+27+25+31+...+41, i get 216 instead of 210. I'm using student-id…
weizer
  • 1,009
  • 3
  • 16
  • 39
0
votes
1 answer

Google Data Studio Case When Two Sets of Criteria

I have a dataset in Google Sheets that records updates to projects over time: Update_Date Project_Code Status 01/09/21 0001 Proposal 01/09/21 0002 Delivery 01/09/21 0003 Business Case 01/10/21 …
Ant
  • 313
  • 5
  • 19
1
2