+ Reply to Thread
Results 1 to 2 of 2

Display Cell Range if it meets Criteria x

  1. #1
    Registered User
    Join Date
    12-01-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    38

    Display Cell Range if it meets Criteria x

    Example.xlsxHi,

    I wondered if anyone is able to assist. I would like Excel to display a cell range if another cell range meets a certain criteria. Attached is the spreadsheet and the data I wish to work with. Essentially this is what I am trying to achieve but I am a complete beginner when it comes to Formula and VBA.

    If I was to write it in my thought process it would be like something like

    If Cell range N5:O10 contains text "N" then display all results that corrospond to "N" in the adjacent cell range I5:J10 but ingnore cells if they contain the text "[New Date]" and "Example". Display all these results in Cells A3 onwards. Using the example attached, the results I would expect to see are located in Cells A3:D4

    I hope that makes sense. I appreciate all efforts and any help that you are able to share.

    Thanks!

    Karo
    Last edited by karobonas; 12-21-2012 at 12:00 PM. Reason: Attachment added

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Display Cell Range if it meets Criteria x

    Hi Karo,

    I believe you need to learn Advanced Filters and this problem is done. See the attached where I've done an Advanced Filter with your data. Hope this helps.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

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