Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding duplicate rows
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Duplicate rows forever... | Excel Worksheet Functions | |||
Need macro to remove duplicate rows in a wksht with same order# | Excel Discussion (Misc queries) | |||
Deleting All Rows for Duplicate Entries Except Those With Most Items In Row | Excel Discussion (Misc queries) | |||
Finding Duplicate Names from Different Lists... | Excel Discussion (Misc queries) |