Hi
How many worksheets do you have? Is it possible that the duplicated entries
are located on two or more worksheets?

pa

"heyredone" wrote:

I have numerous worksheets with employee daily time punch data over a period
of 4 years. I have discovered duplicate entries and want to weed (and
eventually delete) out the duplicates. Can I find the duplicates without
having to manually look at each line entry. Worksheet is set up as follows:

Columns:
A = First Name
B = Last Name
C = Badge No.
D = Store No.
E = ScanDttm (Date)
F = [blank on purpose]
G = Time [this translates to a time punch In or Out on a given date (Column E)

Eventually, I will create Columns H thru K for each person as "Time In",
"Time Out", "Time In" and "Time Out" so I can see time punches for a given
day left to right rather than downward. Some time back another Discussion
Group member provided me with a formula to use for this purpose that will
work beautifully.

I just need to weed out the duplicates first.

Thank you!
--
heyredone