H
heyredone
I have numerous worksheets with daily time punch entries covering 4 years. I
have discovered duplicates and want to weed (and eventually delete) out the
duplicates. Can I do this without looking at each line entry manually?
Worksheets are set up as follows:
Columns:
A = First Name
B = Last Name
C = Badge No.
D = Store No.
E = ScanDttm (Day)
F = [purposely blank]
G = Time punch [as in time punches In & Out for a given day]
I am thinking that the formula or function would need to look at multiple
pieces of data in a given line entry to determine if it duplicative of
another line entry.
Thank you for your anticipated help.
have discovered duplicates and want to weed (and eventually delete) out the
duplicates. Can I do this without looking at each line entry manually?
Worksheets are set up as follows:
Columns:
A = First Name
B = Last Name
C = Badge No.
D = Store No.
E = ScanDttm (Day)
F = [purposely blank]
G = Time punch [as in time punches In & Out for a given day]
I am thinking that the formula or function would need to look at multiple
pieces of data in a given line entry to determine if it duplicative of
another line entry.
Thank you for your anticipated help.