ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Duplicated Names In List (https://www.excelbanter.com/excel-discussion-misc-queries/84221-duplicated-names-list.html)

mik00725

Duplicated Names In List
 

Hello all !!

I have in column A list of over 1,000 names. In this list the names
are duplicated. How can I filter/retrieve or modify this list to have
all the names but not duplicated.


You help is greatly appreciated.
MIK


--
mik00725
------------------------------------------------------------------------
mik00725's Profile: http://www.excelforum.com/member.php...o&userid=16169
View this thread: http://www.excelforum.com/showthread...hreadid=534639


Gord Dibben

Duplicated Names In List
 
DataFilterAdvanced Filter.

"Unique records only" and "Copy to a new location".


Gord Dibben MS Excel MVP

On Thu, 20 Apr 2006 11:00:30 -0500, mik00725
wrote:


Hello all !!

I have in column A list of over 1,000 names. In this list the names
are duplicated. How can I filter/retrieve or modify this list to have
all the names but not duplicated.


You help is greatly appreciated.
MIK




All times are GMT +1. The time now is 08:40 PM.

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