Finding duplicate time punch data

H

heyredone

I have numerous worksheets with daily time punch line entries. I have
discovered duplicate line entries that I want to weed (and eventually delete)
out. Is there a way I can easily locate the duplicates, then delete, without
looking at each line entry manually. Worksheets are formatted as follows:

Columns:
A = First Name
B = Last Name
C = Badge No.
D = Store No.
E = ScanDttm (Date)
F = [purposely left blank]
G = Time punch

Example duplicate:

First Name Last Name Badge Store ScanDttm [blank] Time punch
Carlos Lopez 600893 2621 1/6/2005 9:08:00 AM
Carlos Lopez 600893 2621 1/6/2005 2:26:00 PM
Carlos Lopez 600893 2621 1/6/2005 9:08:00 AM
Carlos Lopez 600893 2621 1/6/2005 2:26:00 PM

Some have 4 entries in a given day [time in, time out, time in, time out]
where duplicates have occurred, giving me 8 line entries for one person in
one day.

Your help would be most appreciated! Thank you!
 

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

Top