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!
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!