I have an array that I am trying to use. I want it to match based on three values. The first (listed in the formula as $B$9) is a name, the second is a start date ($H$9) and the third is an end date ($N$9).
I added the And() function to try to add the additional variables to the small() array, but it didn't work.
It works perfect when I don't use the start dates and end dates, but I get more data then I want... I just want a picture of the data during a time frame. The Dates are stored in column DA on the database worksheet.