dcsimg
Results 1 to 3 of 3

Thread: [RESOLVED] Excel 365: How to pick every name once only from a list?

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Apr 2014
    Posts
    20

    Resolved [RESOLVED] Excel 365: How to pick every name once only from a list?

    Hope there is a solution for my problem.
    I have a big list if names in column A from “Sheet1”, most of these names are repeated more than once. I need to create a function in different worksheet “Sheet2” listing every name in my list but once only.
    Is there a way to do that without programming code but just direct functions?

  2. #2
    PowerPoster
    Join Date
    Oct 2008
    Location
    Midwest Region, United States
    Posts
    3,534

    Re: Excel 365: How to pick every name once only from a list?

    I'd suggest using the Advanced Filter on this page:

    http://www.excelhowto.com/5-ways-to-...lues-in-excel/

  3. #3

    Thread Starter
    Junior Member
    Join Date
    Apr 2014
    Posts
    20

    Re: Excel 365: How to pick every name once only from a list?

    Thanks a lot .. It works

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width