I've got a worksheet, and I'm looking to find the date of the first occurrence of class T1, with a type of A or B (I don't care about type C). I was using an index with match, but I added the type requirement, and haven't been able to get anything to work. Thanks.
A B C 1 Date Type Class 2 1/4/15 C T1 3 1/3/15 A T2 4 1/2/15 B T2 5 1/1/15 C T1 6 12/31/14 B T1
First = earliest date or first = lowest row number???
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Lowest row number. (most recent date)
This may help
http://exceltactics.com/vlookup-mult...g-index-match/
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Here, try this:
Formula:
Please Login or Register to view this content.
Last edited by zbor; 01-14-2015 at 06:48 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks