Results 1 to 4 of 4

List dates when multiple criteria is met

Threaded View

  1. #1
    Registered User
    Join Date
    06-22-2009
    Location
    San Francisco, CA
    MS-Off Ver
    Excel 2007
    Posts
    38

    List dates when multiple criteria is met

    Hi!

    So I'm having a bit of trouble listing dates when multiple criteria is met. I have attached a sample of my situation. This is just a portion as the actual data information is 10000+ rows long.

    I have a hard time explaining this but basically what I want is something like this:

    - Find the first date (Column D) where A="Griffin, Stewie" and g="16" in the "Paste" tab and list that date in cell G4 of the SAT tab.

    Now find the next date where both those criteria are met. and list that in P4 in SAT tab.
    and so on...

    In the sample I manually entered is what I would like it to look like in Row 7.

    I apologize if this sounds confusing, but I was having a hard time explaining this. I hope that the sample workbook makes it a lot easier to understand.

    Thanks.
    Attached Files Attached Files
    Last edited by PowerSchoolDude; 03-10-2010 at 05:13 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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