ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Deleting multiple lines (https://www.excelbanter.com/excel-discussion-misc-queries/48390-deleting-multiple-lines.html)

tammytlc October 3rd 05 10:56 PM

Deleting multiple lines
 
I have a about 25000 + codes in one column (A) some of the codes are
duplicated 7 or 8 times. some 1 or 2. How do I remove the duplicates. With
out doing it by clicking on each line individually?

Michael October 3rd 05 11:49 PM

Hi. Check out Chip Pearson's site: http://www.cpearson.com/excel/duplicat.htm
--
Sincerely, Michael Colvin


"tammytlc" wrote:

I have a about 25000 + codes in one column (A) some of the codes are
duplicated 7 or 8 times. some 1 or 2. How do I remove the duplicates. With
out doing it by clicking on each line individually?



All times are GMT +1. The time now is 09:14 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com