Count first instance of entry only.

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)
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIFS with No Criteria 1
Pivot table calculated field Count(field) / sum(field) 0
list items from one table in another table based on value in first table 2
How to show a count of Unique IDs in a Pivot Table 2
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Vlookup 1
Could a pivot table handle this situation? 1
PIVOT - COUNT IF "YES" 1

Top