Hello Excel Experts!
I need to get the Event Name to show in the weekly tab during the time of the event along with, if possible, the start and end times.
I currently have a COUNTIF in there for the times, but I do not know how to let it give the Event Name from the Event List. This is what I currently have:
=COUNTIFS(CSEvents[Date of Event], $C20, CSEvents[Start Time], "<="&N$6, CSEvents[End Time],">="&N$6,CSEvents[Calendar Entry],INDEX($M$2:$M$5,MOD(ROWS($1:19),6)))*N$6
I have also played around with the formula below, but it does not give the start and end times, nor the name:
{=IFERROR(INDEX(CSEvents,MATCH(TEXT($C41+O$6,"mmddyyyhh")&$M$5,TEXT(CSEvents[[Start]:[Start]],"mmddyyyhh")&CSEvents[[*Kind of Event]:[*Kind of Event]],0),2),IFERROR(INDEX(CSEvents,MATCH(TEXT($C41+O$6,"mmddyyyhh")&$M$5,TEXT(CSEvents[[Finish]:[Finish]],"mmddyyyhh")&CSEvents[[*Kind of Event]:[*Kind of Event]],0),3),""))}
Suggestions?
I need to get the Event Name to show in the weekly tab during the time of the event along with, if possible, the start and end times.
I currently have a COUNTIF in there for the times, but I do not know how to let it give the Event Name from the Event List. This is what I currently have:
=COUNTIFS(CSEvents[Date of Event], $C20, CSEvents[Start Time], "<="&N$6, CSEvents[End Time],">="&N$6,CSEvents[Calendar Entry],INDEX($M$2:$M$5,MOD(ROWS($1:19),6)))*N$6
I have also played around with the formula below, but it does not give the start and end times, nor the name:
{=IFERROR(INDEX(CSEvents,MATCH(TEXT($C41+O$6,"mmddyyyhh")&$M$5,TEXT(CSEvents[[Start]:[Start]],"mmddyyyhh")&CSEvents[[*Kind of Event]:[*Kind of Event]],0),2),IFERROR(INDEX(CSEvents,MATCH(TEXT($C41+O$6,"mmddyyyhh")&$M$5,TEXT(CSEvents[[Finish]:[Finish]],"mmddyyyhh")&CSEvents[[*Kind of Event]:[*Kind of Event]],0),3),""))}
Suggestions?