Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Keeping duplicate rows
I have a spreadsheet that has 15 columns and about 5400 rows. Column A has
the part number. Is there a function or macro that can run though the spreadsheet and keep the whole row based on the fact that there are duplicate part numbers in column A and delete the rows that are not duplicate. All I want to see are the complete rows of all duplicate rows. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find duplicate rows then deleting them | Excel Worksheet Functions | |||
Showing Duplicate Rows | Excel Discussion (Misc queries) | |||
How to delete duplicate rows in Excel 2000? | Excel Discussion (Misc queries) | |||
Showing Duplicate rows in excel | Excel Discussion (Misc queries) | |||
Duplicate Rows | Excel Worksheet Functions |