ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do you dedupe a list in excel with parameter? (https://www.excelbanter.com/excel-worksheet-functions/83719-how-do-you-dedupe-list-excel-parameter.html)

mags

How do you dedupe a list in excel with parameter?
 
I have a very large mailing list in an excel format with duplicates and
triplicates that I would like to dedupe.

Bob Phillips

How do you dedupe a list in excel with parameter?
 
Create a new unique list in another column with DataFilterAdvanced
Filter... It has a unique records option.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mags" wrote in message
...
I have a very large mailing list in an excel format with duplicates and
triplicates that I would like to dedupe.





All times are GMT +1. The time now is 07:14 PM.

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