Sheet "DTL" contains a Table ("Details") in Columns A:X
On another sheet I have a list of names in Column B which I need to lookup in the "Details" table and return multiple values. "Name" = column E in the table.
I need to find the first 16 values that relate to "name".
Then I need to find the first 10 values of name ONLY if "Major" = "A" (Column X in the table).
I am assuming an array formula will be what I need, however, I don't know enough about array formulas to know where to start!
I have attached a sample workbook with a before and after and the table to look for values.
In my actual workbook there will be many more than 16 values for each name and many more than 10 values for each "name" + "Major = A".
I am trying to return the 16 and 10 most recent values based on the date. The table will be sorted in date order (newest to oldest).
Any assistance appreciated.
Bookmarks