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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding duplicate rows
Try concatenating everything you want to compare into a helper column and use
the countif function. Let's say your data is in column A2:A100. Add another helper column (for now) with =COUNTIF(A$2:A2,A2) and copy down. Any values greater than 1 will be duplicates. You can autofilter and remove them fairly quickly. " wrote: 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 |
Reply |
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) |