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.

Can you please help me?

I have attached a screen show of what I have so far.

excel

Formulas and Functions

Patrick2788
Mar 09, 2020
rbeattie222
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

12 Replies

Patrick2788
Silver Contributor
Mar 09, 2020
rbeattie222
Since 365 wasn't tagged, I'll presume you don't have access to FILTER.

See attached.
Formula.xlsx10 KB
- rbeattie222
  Copper Contributor
  Mar 09, 2020
  Patrick2788
  
  Hi Patrick sorry, I have Microsoft Office Professional 2010
  
  Hope you can still help me?
  
  Thanks Ross
  - Patrick2788
    Silver Contributor
    Mar 09, 2020
    rbeattie222
    Yes, take a look at my attached workbook.

Forum Discussion

Need help on a formula please