Hi Guys,
I have the following Data in cells A1:
Start Day Finish Day Vendor
01/09/2017 03/09/2017 ABC
03/09/2017 05/09/2017 DEF
04/09/2017 06/09/2017 XYZ
06/09/2017 08/09/2017 QWE
06/09/2017 08/09/2017 ABC
09/09/2017 11/09/2017 YOU
10/09/2017 12/09/2017 ABC
12/09/2017 14/09/2017 DEF
In cells F1 onwards I am sequentially listing dates down like so:
1/9/2017
2/9/2017
3/9/2017
etc...
I'd like to right a formula in cell G1 (that I can drag to the right) that enables me to pull all the vendors by day. For example, this is what the data would look like for the first few days starting in cell F1.
01/09/2017 ABC
02/09/2017 ABC
03/09/2017 ABC DEF
04/09/2017 DEF XYZ
05/09/2017 DEF XYZ
06/09/2017 XYZ QWE ABC
I am essentially trying to create an array formula that will pull all the vendors available by a particular day (of which there are multiple listed over several days).
Thanks very much!
Larry
Bookmarks