Results 1 to 7 of 7

Creating a comma separated list from a column of numbers, omitting duplicates, spaces

Threaded View

  1. #1
    Registered User
    Join Date
    10-07-2011
    Location
    USA, PA
    MS-Off Ver
    Excel 2003
    Posts
    6

    Creating a comma separated list from a column of numbers, omitting duplicates, spaces

    Hello Excel forum community! I seek your expert advice again.

    What I'm trying to do is take information that is located in a column of numbers, and be automatically forwarded to a single cell with commas between each number, and omitting any duplicates and spaces (empty cells), with them also being in numerical order.

    For example:
    8765
    8765
    9803
    2011
    8765
    0008

    in six columns would be taken to a single cell as:
    0008, 2011, 8765, 9803


    In the sample workbook attached, I have information in sheet two, column A and needs to be sent automatically as a comma'ed list to sheet one, B1

    On sheet two, the space for potential data input is between A2 and A20

    I can include my actual project (with dummy information) if the sample project doesn't explain clearly enough what I need to accomplish.

    I only have limited knowledge of programing with VBA,so a code snippet would be preferred.

    Thank you in advanced!
    Attached Files Attached Files
    Last edited by Higoten; 12-16-2011 at 08:52 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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