+ Reply to Thread
Results 1 to 3 of 3

Can Excel automatically generate a list into a column from existing data in another column

  1. #1
    Registered User
    Join Date
    01-21-2013
    Location
    Illinois
    MS-Off Ver
    Excel 2011
    Posts
    2

    Can Excel automatically generate a list into a column from existing data in another column

    Currently, I have an extremely large (thousands of rows) spreadsheet which contains the following (I'm leaving out other irrelevant columns):

    Column C (Date)
    Column D (Name of Product Sold)

    Column F (Price)

    Column N - the issue

    What I want is to have Excel automatically (as soon as data is entered into column D) pull the unique product names in column D and list them alphabetically in column N. In column D, there are about 30 different product names total and they appear numerous times throughout the column.

    I'm sure there's an easy way to do this, but I'm sure you guys are much faster to figure it out than I'd be on my own!

    Thanks.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Can Excel automatically generate a list into a column from existing data in another co

    Hi.

    Post a sample data file.
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Registered User
    Join Date
    01-21-2013
    Location
    Illinois
    MS-Off Ver
    Excel 2011
    Posts
    2

    Re: Can Excel automatically generate a list into a column from existing data in another co

    Sample Data.xlsx Hopefully this works

+ Reply to Thread

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