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.
--
heyredone

how do you find the row is duplicate ?

give an example.


On Feb 12, 11:43*pm, heyredone
wrote:
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.
--
heyredone