Hello,
This is a very specific question to a very specific problem, that is described in text boxes on the attached spreadsheet.
Basically (as possible) I have a INDEX/MATCH formula that is looking for the lowest value that falls within a date range. There are 3 date ranges that the table covers. All works well UNLESS the lowest value within 1 date range is identical to the lowest value within another date range. In this case, the lowest value for theearlier date range and associated times/dates/values/etc are assigned to both date ranges.
Please have a look at the attachment and hopefully the question will be more clear.
Thanks!
Bookmarks