tag:blogger.com,1999:blog-8807805591547673516.post6153791080081322970..comments2024-02-28T08:14:50.756-08:00Comments on Cloud Computing -- Google Docs Way: yogi_Use CountUnique To Count Instances Of Week in Column C For Specified Project In Column DYogi Anandhttp://www.blogger.com/profile/10862524957172908621noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8807805591547673516.post-67538298188041658562019-03-12T14:57:09.046-07:002019-03-12T14:57:09.046-07:00This was a good solution but I'm facing anothe...This was a good solution but I'm facing another challenge, I need to filter with a date range.<br />For 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)))Anonymoushttps://www.blogger.com/profile/07991808647018655360noreply@blogger.com