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.
Bookmarks