Timestamp to Pivot table case count

Vankootens

New member
Joined
Jan 11, 2016
Messages
3
Reaction score
0
Points
0
Excel Version(s)
Office 365
I have an excel doc I use weekly step up like so:
Rows:
A: ID# - - B: timestamp

When data is entered into row A the timestamp populates(via macros).
I would like to see how many cases I do on a daily basis. I believe a Pivot would be the best approach but can't seem to figure this out. The Pivot chart would update after each timestamp.

Thank you in advance!
 
Back
Top