Forum Discussion
Excel 2016 Populating a calendar with multi day events and multiple events per day from data table
Hi experts, I manage multiple calendars for execs and I like to keep their calendars as clear as possible. The issue lies with there being so many All Day events in their outlook that take up their ...
Without FILTER and TEXTJOIN, the method for doing this is with an INDEX-SMALL array such as:
Ctrl+Shift +Enter to define as an array in Excel 2016
=IFERROR(INDEX(Items!$B$1:$B$8,SMALL(IF(Items!$A$1:$A$8=D$2,ROW(Items!$B$1:$B$8)),ROW($A1))),"")Sample workbook attached.
