Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: formula to list all items that match criteria

  1. #1
    New Member
    Join Date
    Sep 2008
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default formula to list all items that match criteria

    hi,

    I would like a formula that would list all the items in row B that match the criteria in row A. the first cell with formula would list the first item, the second cell with the formula would list the next item, and so forth. Also, column B might have a duplicates that should be listed. Is this possible? I cannot manipulate the order of the original items (ie, filters) because this data is being used to derive other formulas.

  2. #2
    Board Regular
    Join Date
    Jul 2008
    Location
    Surrey, UK
    Posts
    1,521
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula to list all items that match criteria

    look at the MATCH function in Excel help. Thanks

    Kaps
    Read my Excel blog on

    http://simplyspreadsheets.wordpress.com/

    For more ways I can help you with Excel :-

    www.simplyspreadsheets.co.uk

  3. #3
    Board Regular Mike Blackman's Avatar
    Join Date
    Jun 2007
    Location
    Basingstoke, UK
    Posts
    2,478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula to list all items that match criteria

    Hi,

    Could you not use the Advanced Autofilter - Criteria to obtain this?

    This method would not effect you data table in anyway so therefore would not impact on your dependant formula's.

    See here.
    Regards

    Mikey B

  4. #4
    New Member
    Join Date
    Sep 2008
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula to list all items that match criteria

    It is unbelievable how much I DON'T know. Thanks kindly Schwarzmanne.

  5. #5
    Board Regular Mike Blackman's Avatar
    Join Date
    Jun 2007
    Location
    Basingstoke, UK
    Posts
    2,478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula to list all items that match criteria

    Your not alone buddy, were all in a constant state of learning.
    Regards

    Mikey B

  6. #6
    New Member
    Join Date
    Sep 2008
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula to list all items that match criteria

    one more question. is there a possibility for this data to update automatically (I am assuming no)?

  7. #7
    New Member
    Join Date
    Sep 2008
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula to list all items that match criteria

    Can this be done with a formula! Please help.

  8. #8
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,405
    Post Thanks / Like
    Mentioned
    40 Post(s)
    Tagged
    8 Thread(s)

    Default Re: formula to list all items that match criteria

    Quote Originally Posted by gnmthead View Post
    Can this be done with a formula! Please help.
    See:

    http://www.mrexcel.com/forum/showthread.php?t=231882

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •