Results 1 to 6 of 6

Expanding a list to repeat values based on another column

Threaded View

  1. #1
    Registered User
    Join Date
    08-09-2004
    Location
    auckland
    MS-Off Ver
    MS Office Professional Plus 2016
    Posts
    72

    Expanding a list to repeat values based on another column

    Hi,

    I have a list of addresses and names.

    Down one side I have numbers which correspond to properties on another worksheet. Each number appears at least 3 times. On the same page is another column of the same numbers, which don't repeat. I would like to take the suburb name from next to the non repeating numbers and populate the column next to the corresponding numbers which repeat themselves.

    Is this possible?

    Let me know if I didn't make sense and I'll try and clarify.

    Thanks so much
    Ryan
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Segmenting a continuously expanding list based on unique values.
    By Duct in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2019, 02:20 PM
  2. Extract list of values from one column based on values in another column
    By The Speculator in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-21-2019, 11:22 PM
  3. [SOLVED] Consecutive repeat of column headings based on cell values
    By mikear82 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-24-2018, 08:49 AM
  4. Create unique list based on expanding criteria
    By Matster in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-06-2016, 06:55 PM
  5. Replies: 2
    Last Post: 10-25-2013, 07:01 PM
  6. Display differances in values on expanding list
    By macroRoniAndCheese in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2013, 11:56 AM
  7. Replies: 2
    Last Post: 09-28-2011, 08:43 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