Copy duplicate data to new worksheet
Posted by A.R. on May 14, 2001 12:34 PM
I have a column displaying company name. I have to copy the rows that have the same company names to a new worksheet. For example, there are two "Company A" in rows 3 and 4, each with a different address, ID # etc. There are three Company B, 2 Company C, etc. I would copy the above data to a new worksheet. This is a very large worksheet (18,000 rows) and I tried using the Filter feature, but that only deletes duplicate records. Is there a way for Excel to find those duplicate data (company name) all at once, and then copy those rows to a new worksheet?