Example.xlsx
Hello everybody. Hopefully someone can help me with a problem I'm having.
I have attached an example spreadsheet. I am trying to find the first (smallest) and last (greatest) dates in column A which match certain criteria in columns B, C and D.
The qualifying rows (in columns B,C and D) would be AAA, AAB, BAA and BAB. I have highlighted the qualifying rows in the table yellow.
I have used an array formula using MIN, INDEX and MATCH in cell B16 to successfully find the first date (15/2/1988), but producing the last (1/3/1989) in B18 is proving more problematic.
Does anybody know how I might do this?
Thanks in advance,
Simon.
P.S. I need the cell to return "None" if there are no matching rows, hence the use of IFERROR and 999999 in my first formula. I'm sure this formula could be done better, but at least it works.
Bookmarks