Thursday, June 13, 2013

yogi_Use CountUnique To Count Instances Of Week in Column C For Specified Project In Column D

                                          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/spreadsheet/ccc?key=0AoSVxswDPXtwdE5HcGZ4Y0lsMlZtZmFHRjZTcnpGS0E&usp=sharing

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?

------------------------------------------------------------------------------------------------------------------------------------