i have in a list. there are almost 2000 rows. I ould like to be able to
find
duplicates by comparing hours and months and year and name then
highlight the
duplicates.

have a worksheet that has

Client Task Description Hours Month Day Year Name
soandso payroll type of p/r 1.00 jan 1

2005 me
whats bookkeeping type of bkpg 2.00 febuary 4

2006 him

I get the list by coping and pasting values from timesheets to a
worksheet
named all time data. i am looking for a way to make sure that the
information I enter is correct and not duplicates.

Thanks for any thoughts

Gary Reger