+ Reply to Thread
Results 1 to 4 of 4

Need sheet to automatically populate next unique entry entered on a different sheet

  1. #1
    Forum Contributor
    Join Date
    10-11-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    230

    Need sheet to automatically populate next unique entry entered on a different sheet

    I'm looking for a way to have a unique list automatically created and updated as new entries are added to another column.

    I have a sheet that has a column of entries, some repeating and some not. I'd like to have another sheet that automatically populates the next new and unique entry when it is entered on the first sheet. Is this possible?

    Say Sheet 1 has in column A the following entries:
    Red
    Blue
    Red
    Blue
    Green
    Yellow
    Green
    Red

    Sheet 2 should have the following list:
    Red
    Blue
    Green
    Yellow

    Then when a new color is added to sheet 1 that's not already on the list, it will appear in the next available cell on Sheet 2.

    Thanks.

    Nadine

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Need sheet to automatically populate next unique entry entered on a different sheet

    In B2 and drag formula down

    =IFERROR(INDEX($A$2:$A$9,MATCH(0,INDEX(COUNTIF($B$1:B1,$A$2:$A$9),,),)),"")

    A
    B
    1
    2
    Red Red
    3
    Blue Blue
    4
    Red Green
    5
    Blue Yellow
    6
    Green
    7
    Yellow
    8
    Green
    9
    Red
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Contributor
    Join Date
    10-11-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: Need sheet to automatically populate next unique entry entered on a different sheet

    Thanks so much!

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Need sheet to automatically populate next unique entry entered on a different sheet

    You're welcome and thank you for the feedback!

    Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

+ 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. Replies: 2
    Last Post: 02-13-2013, 03:14 PM
  2. Replies: 4
    Last Post: 03-22-2011, 09:44 PM
  3. Populate Sheet Based on Entry on Another Sheet
    By chocolate_ty2000 in forum Excel General
    Replies: 0
    Last Post: 03-15-2011, 02:29 PM
  4. automatically show data entered on another sheet within the workbo
    By leah in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-24-2006, 09:55 AM
  5. can entered data in sheet 1 be automatically pasted in sheet 2
    By Adnan Jahangir in forum Excel General
    Replies: 1
    Last Post: 02-23-2006, 06:10 AM

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