+ Reply to Thread
Results 1 to 3 of 3

List data from relevant cells if criteria matched in column

  1. #1
    Registered User
    Join Date
    09-29-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    73

    List data from relevant cells if criteria matched in column

    Hi guys

    A very simple one here but I can't work it out (tried searching but my query involves the words 'if', 'match', 'cells' and 'list' so I'm finding all sorts of answers on the web but not the answer I'm looking for.

    If word in column C matches what I am looking for (either as fixed "word" or based on a specified cell) then list the data from the cells in the corresponding row from column A. So I have a list of employees and what area they work in. If they work in "sales" then all the names should be listed in one cell.

    I've attached an example.

    Many thanks

    D
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: List data from relevant cells if criteria matched in column

    Hi DVS,

    I have tried with helper columns

    Please have a look.

    Note: VBA code used here is not mine.
    Attached Files Attached Files
    Please click 'Add reputation', if my answer helped you.

  3. #3
    Registered User
    Join Date
    09-29-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    73

    Re: List data from relevant cells if criteria matched in column

    Thanks ramananhrm. I didn't really want to use VBA code but this worked without any problems. Cheers.

+ 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: 4
    Last Post: 05-03-2013, 12:09 PM
  2. [SOLVED] Copy adjacent cells based on matched cell criteria
    By asdfwqefwe3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2013, 02:26 AM
  3. Macro to loop through all worksheets, pulling a range of cells if criteria matched.
    By strictlydiesel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2009, 12:37 AM
  4. [SOLVED] Copying matched criteria plus relevant columns to new worksheet
    By mattguerilla in forum Excel General
    Replies: 3
    Last Post: 07-29-2005, 11:05 AM
  5. Copying matched criteria and relevant data columns to a new worksh
    By mattguerilla in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2005, 11:05 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