Google Spreadsheet Post #1240
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jun 13, 2013
user leniel (http://productforums.google.com/forum/?zx=2mu4w5huk7j7#!category-topic/docs/spreadsheets/6VLRHl7K4Bs)
How to count unique values in column when data is filtered?
Hello friends,
I'd like to know how to count unique values when using a filter. Take for example this spreadsheet:
https://docs.google.com/
As you can see, column Project is filtered where Project 2 is selected. It should report 4 in cell C2 as a result of =COUNTUNIQUE(C4:C). It's reporting 7, that is, it's considering all the values in column C ignoring the filter. If I selected Project 1, it should report 3 and finally if all projects are selected it should then report 7.
How can achieve COUNTUNIQUE with filtered data?
------------------------------------------------------------------------------------------------------------------------------------
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jun 13, 2013
user leniel (http://productforums.google.com/forum/?zx=2mu4w5huk7j7#!category-topic/docs/spreadsheets/6VLRHl7K4Bs)
How to count unique values in column when data is filtered?
Hello friends,
I'd like to know how to count unique values when using a filter. Take for example this spreadsheet:
https://docs.google.com/
As you can see, column Project is filtered where Project 2 is selected. It should report 4 in cell C2 as a result of =COUNTUNIQUE(C4:C). It's reporting 7, that is, it's considering all the values in column C ignoring the filter. If I selected Project 1, it should report 3 and finally if all projects are selected it should then report 7.
How can achieve COUNTUNIQUE with filtered data?
------------------------------------------------------------------------------------------------------------------------------------
This was a good solution but I'm facing another challenge, I need to filter with a date range.
ReplyDeleteFor instance, col A has all the dates and I need to get the COUNTUNIQUE(FILTER(A:A,A:A>=DATE(2019,03,04) AND A2:A<=DATE(2019,03,10)))