Sunday, November 17, 2013

yogi_Count Instances of Names in Column A For A Specified Date (or all dates) In Column B

                                          Google Spreadsheet   Post  #1423
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov 17, 2013
post by Clare-Noel Holdinghaus question by ajta@0316 (http://productforums.google.com/forum/?zx=emvk7dhbcu1y#!mydiscussions/docs/oMozBKn-1mY)
ive read your post.. will this also work on TIMESTAMP, but i just want to filter the EXACT DATE regardless of the time?

10/29/2013ubert
10/28/2013ubert
10/30/2013jessica
10/30/2013ubert
10/30/2013susan
10/30/2013grace
10/30/2013Aguilar
10/28/2013ubert
10/31/2013jhimpeter
10/26/2013jessica
10/26/2013angela
10/28/2013ubert
10/28/2013ubert
11/1/2013marc
10/31/2013jhimpeter
10/26/2013jhimpeter
11/1/2013jessica
11/1/2013marc

Count how many times the name appeared on a specific date.. expected result will be something like:

jessica4
marc8
Ubert16
Jhimpeter5

may first idea would be:

given COL A = timestamp
        COL B = username

D2=unique(B:B)
E2=countif(B:B, D2)

however this would filter all entries regardless of the date... I would like countif based on specific date..

thanks!!
-----------------------------------------------------------------------------------------------
following is a solution to a bit more generalized problem