Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Duplicate Rows
I've not had success using the macros listed to delete
rows where the first cell is the same. For example, * Sheet1 has name in column 1 (shorter file) * Sheet2 has name in column 1 and address in column 2 (longer file) I want Sheet1 to drive the selection of rows in Sheet2, resulting in a name and address subset file of Sheet2. Thank you, Connie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Duplicate Rows
in sheet2 put a formula in column 3
=if(countif(Sheet1!A:A,A1)0,"Keep","Delete") You can copy this down the column, then use the Autofilter to extract the rows you want. Use the same approach in a macro. -- Regards, Tom Ogilvy Connie wrote in message ... I've not had success using the macros listed to delete rows where the first cell is the same. For example, * Sheet1 has name in column 1 (shorter file) * Sheet2 has name in column 1 and address in column 2 (longer file) I want Sheet1 to drive the selection of rows in Sheet2, resulting in a name and address subset file of Sheet2. Thank you, Connie |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Duplicate Rows
Tried your suggestion but it only worked by placing a Keep
in the first row of sheet 2....all other rows said delete....thanks! -----Original Message----- in sheet2 put a formula in column 3 =if(countif(Sheet1!A:A,A1)0,"Keep","Delete") You can copy this down the column, then use the Autofilter to extract the rows you want. Use the same approach in a macro. -- Regards, Tom Ogilvy Connie wrote in message ... I've not had success using the macros listed to delete rows where the first cell is the same. For example, * Sheet1 has name in column 1 (shorter file) * Sheet2 has name in column 1 and address in column 2 (longer file) I want Sheet1 to drive the selection of rows in Sheet2, resulting in a name and address subset file of Sheet2. Thank you, Connie . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Duplicate Rows
It works fine for me and should work for you. I suspect your problem lies
with your data not matching. Possibly you have blanks spaces on the end of your data in one sheet or the other. -- Regards, Tom Ogilvy Connie wrote in message ... Tried your suggestion but it only worked by placing a Keep in the first row of sheet 2....all other rows said delete....thanks! -----Original Message----- in sheet2 put a formula in column 3 =if(countif(Sheet1!A:A,A1)0,"Keep","Delete") You can copy this down the column, then use the Autofilter to extract the rows you want. Use the same approach in a macro. -- Regards, Tom Ogilvy Connie wrote in message ... I've not had success using the macros listed to delete rows where the first cell is the same. For example, * Sheet1 has name in column 1 (shorter file) * Sheet2 has name in column 1 and address in column 2 (longer file) I want Sheet1 to drive the selection of rows in Sheet2, resulting in a name and address subset file of Sheet2. Thank you, Connie . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting duplicate rows | Excel Discussion (Misc queries) | |||
Find duplicate rows then deleting them | Excel Worksheet Functions | |||
deleting duplicate rows | Excel Discussion (Misc queries) | |||
Deleting duplicate rows | Excel Discussion (Misc queries) | |||
Deleting Duplicate Rows | Excel Discussion (Misc queries) |