I've done some research, but am running out of time on getting this done.
We have a report that is ran every two weeks. This report shows the date and time in column A that an employee swipes his/her badge at a specific terminal. I need to be able to do a count total for each day, which seemed pretty simple by itself.
The caveat here is, They don't want me to modify the report any (as in get rid of the time...hence I can't use the actual date in a lookup), and it has to be a function that can be copied and then dropped in to the next report in two weeks and have it work without any modification.
a sample:
Event Date Event/Point Description Logical Device Last Name First Name Employee ID EDR COST
1/11/2013 12:36 PM Access Granted KSC-E167 EDR Turnstile F DIANA 200000 0
1/10/2013 11:38 AM Access Granted KSC-E167 EDR Turnstile F DIANA 200000 0
1/17/2013 12:40 PM Access Granted KSC-E167 EDR Turnstile F DIANA 200000 0
1/17/2013 12:40 PM Access Granted KSC-E167 EDR Gate F DIANA 200000 0
1/22/2013 12:04 PM Access Granted KSC-E167 EDR Turnstile F DIANA 200000 0
1/15/2013 11:55 AM Access Granted KSC-E167 EDR Turnstile W Amanda 200001 3
1/10/2013 11:59 AM Access Granted KSC-E167 EDR Turnstile D Mike 200005 0
1/22/2013 12:07 PM Access Granted KSC-E167 EDR Turnstile D Mike 200005 0
1/18/2013 6:22 PM Access Granted KSC-E167 EDR Turnstile D Mike 200005 0
1/12/2013 6:10 PM Access Granted KSC-E167 EDR Turnstile D Mike 200005 0
What I need is a total as follows
1/10/2013 - 2
1/11/2013 - 1
1/12/2013 - 1
and so on.
Any ideas?
pulling my hair out.
Bookmarks