+ Reply to Thread
Results 1 to 3 of 3

Find text references in a table and list all in a another table

  1. #1
    Forum Contributor
    Join Date
    03-24-2009
    Location
    Porto, Portugal
    MS-Off Ver
    Excel 2013
    Posts
    137

    Find text references in a table and list all in a another table

    Hi
    I need to know if there is a way to lookup for references "Task dd-mm-yyyy" in Table 1 and list them all in Table 2 as it shows (Text in Bold is only to highlight the reference I need)

    TABLE 1
    ORDER Schedules
    12345 Task 22-11-2016 Find Wally; Task 15-11-2016 Find Sally; Task 30-10-2016 Find Molly
    23456 Task 20-11-2016 Find Charles; Task 05-11-2016 Find Charlize; Task 25-10-2016 Find Carly
    34567 Task 26-11-2016 Find Rose; Task 08-11-2016 Find Daizy; Task 01-11-2016 Find Tulip
    45678 Task 28-11-2016 Find Ford; Task 03-11-2016 Find Chevy; Task 29-10-2016 Find Tesla
    56789 Task 23-11-2016 Find Bear; Task 20-10-2016 Find Lion; Task 29-10-2016 Find Monkey
    67890 Task 12-11-2016 Find Guitar; Task 06-11-2016 Find Drums; Task 30-10-2016 Find Bass

    TABLE 2
    ORDER AGENDA SCHEDULES
    45678 28-11-2016 Task 28-11-2016 Find Ford
    34567 26-11-2016 Task 08-11-2016 Find Daizy
    56789 23-11-2016 Task 29-10-2016 Find Monkey
    12345 22-11-2016 Task 22-11-2016 Find Wally
    23456 20-11-2016 Task 05-11-2016 Find Charlize
    12345 15-11-2016 Task 30-10-2016 Find Molly
    67890 12-11-2016 Task 12-11-2016 Find Guitar
    34567 08-11-2016 Task 08-11-2016 Find Daizy
    67890 06-11-2016 Task 30-10-2016 Find Bass
    23456 05-11-2016 Task 20-11-2016 Find Charles
    45678 03-11-2016 Task 03-11-2016 Find Chevy
    34567 01-11-2016 Task 01-11-2016 Find Tulip
    12345 30-10-2016 Task 22-11-2016 Find Wally
    67890 30-10-2016 Task 06-11-2016 Find Drums
    45678 29-10-2016 Task 29-10-2016 Find Tesla
    56789 29-10-2016 Task 23-11-2016 Find Bear
    23456 25-10-2016 Task 05-11-2016 Find Charlize
    56789 20-10-2016 Task 29-10-2016 Find Monkey

    I can get the first schedule in each line through a LEFT/RIGHT function formula, but what I really wish is to built a list as table 2.

    Can it be done?

    Thanks in advance.

    Ioncila

  2. #2
    Forum Contributor
    Join Date
    03-24-2009
    Location
    Porto, Portugal
    MS-Off Ver
    Excel 2013
    Posts
    137

    Re: Find text references in a table and list all in a another table

    Hi
    I forgot to attach a sheet example
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-24-2009
    Location
    Porto, Portugal
    MS-Off Ver
    Excel 2013
    Posts
    137

    Re: Find text references in a table and list all in a another table

    Any ideas?

+ 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: 6
    Last Post: 06-02-2014, 01:40 PM
  2. Macro to Fill down and across a table, using table references.
    By irishman311 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2013, 07:36 PM
  3. Replies: 5
    Last Post: 10-02-2012, 10:29 AM
  4. (ask) Vlookup to find max in table list.
    By sr_88 in forum Excel General
    Replies: 3
    Last Post: 08-21-2012, 01:39 AM
  5. Replies: 0
    Last Post: 08-02-2012, 09:04 AM
  6. Find missing names in table from list and add row
    By Cicada in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2011, 03:35 PM
  7. Find and list all table names
    By stage in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-23-2011, 09:32 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