Hi,
I'm having a bit of an issue returning a row/s from a table of data within a specified date range.
I've used OFFSET(...MATCH... to return rows based on matching a number, but now I need to return many rows that are within the specified date range.
I have attached a spreadsheet to illustrate:
DATA A4:J10
DATE MIN C16
DATE MAX F16
output range B21:J28
If I were to enter 5/1 in DATE MIN and 10/4 in DATE MAX i would like Project #'s 2, 1 and 3 (see C3) to appear in the output range.
Any direction is greatly appreciated .
Cheers
Cam
Bookmarks