Results 1 to 3 of 3

Get a list of multiple names that match a single criteria in another row

Threaded View

  1. #1
    Registered User
    Join Date
    09-01-2012
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    4

    Get a list of multiple names that match a single criteria in another row

    Looking for a formula for this example below :

    A B C D
    1 JOHN JACK TOM JANE
    2 red blue yellow red

    From this table want to locate and display in box A3 the names who like "red" seperated by a comma.
    So the answer would look like below

    A
    3 JOHN,JANE

    Can someone help me with a formula to do this ?

    Thanks.
    Last edited by JBeaucaire; 09-01-2012 at 03:46 PM. Reason: Corrected thread title to topic only, as per forum rules, don't forget!

Thread Information

Users Browsing this Thread

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

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