Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Duplicates
I have created a formula in column Q which, after filled to the last row of
data identifies all of the duplicates by putting the SSN found in column K, into the corresponding cell in column Q. The formula is =IF(AND(COUNTIF($P$2:$P$1740,P2)1,COUNTIF($G$2:$G $1740,G2)1),K2,"") I need to write some code to delete all duplicates, except one. Any suggestions are eagerly appreciated. Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete duplicates | Excel Worksheet Functions | |||
Delete duplicates? | Excel Discussion (Misc queries) | |||
Delete Duplicates | New Users to Excel | |||
delete duplicates macro to color instead of delete | Excel Programming | |||
Delete duplicates | Excel Worksheet Functions |