Forum Discussion
Solved
Need help on a formula please
I want to have the “company” show up on each day between the start and end date but I cannot seems to figure out. I have been using Index and Aggregate but this is as far as I can get it to go. ...
Add to A2:
=IFERROR(INDEX($K$1:$K$9,SMALL(IF(A$1>=$I$1:$I$9,IF(A$1<=$J$1:$J$9,ROW($K$1:$K$9))),ROW(A1)),1),"")
Ctrl+Shift+Enter to calculate
Hi Patrick sorry, I have Microsoft Office Professional 2010
Hope you can still help me?
Thanks Ross
Yes, take a look at my attached workbook.
I looked at your sheet but I need the company to populate on all the days in the date range?
Thank you
Attached
That is almost what I was looking for, the only issue I see is that I need the range to have a max as well. Example line one you have for Start Mar 2 and End Mar 5 but as you can see Company B still shows up on Mar 6.
I need these to fall in the date range.
Thank you again.
Ross