Row 14 has the formula in there which you suggested. It gives the Event name at 8am and 2pm and at but when I Copy it to row 15 the event that was there from 5-730pm is absent and it states the same event name as row 14. What I am going off is the Presentation doc attached as well. Essentially I would love for it to list the events like this, but again I need to have 7+ events for each day to show, wether it be 4 meetings and 2 product launches and 2 others or antoher combination of them with the max at 7...but could be expanded to more if need be.

Thank you really for your time and advise!

Presentation-What I am kinda going off of..that I would like. https://drive.google.com/file/d/0B2c...it?usp=sharing


Here is the worksheet. https://drive.google.com/file/d/0B2c...it?usp=sharing