+ Reply to Thread
Results 1 to 3 of 3

populate unique list of names from a column

  1. #1
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    populate unique list of names from a column

    Hello Everyone,

    I have a column of 150 country names with many multiples, I would like a formula to populate in as many cells below as needed a unique list of names from the column

    As always any help gratefully appreciated

    Kevin

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: populate unique list of names from a column

    Have you tried copying and pasting them then using the Remove Duplicates functionality? Assuming of course you have Excel 2007 or later. Update your profile so that it's obvious.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Re: populate unique list of names from a column

    Sorry i should have said the list will change from time to time hence a formula
    My profile says MS-Off Ver 13 what else should i add?

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Unique names list from data validation column
    By L plates in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-01-2017, 07:08 PM
  2. [SOLVED] Populate a combobox with unique names from a growing list
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2016, 05:16 AM
  3. Create unique # of worksheets based on list count with unique names
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-24-2016, 09:51 AM
  4. Replies: 7
    Last Post: 12-23-2015, 07:43 AM
  5. [SOLVED] list unique names as a column
    By deanusa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2015, 12:49 PM
  6. Replies: 3
    Last Post: 08-02-2015, 03:50 AM
  7. Replies: 6
    Last Post: 07-08-2012, 03:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1