Count first instance of entry only.

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

List of Names in Column A
Dates in Column B.
Times (hours only) in column C.

How do I count the first instance for each name for the hour only?
(Some names are duplicated and I want a name count in my pivot table)
 
Assuming real times in col C

In D2, copied down:
=IF(COUNTA(A2,C2)<2,"",IF(SUMPRODUCT((A$2:A2=A2)*(HOUR(C$2:C2)=HOUR(C2)))<2,1,""))

Just sum col D for the result
 
Back
Top