=FILTER(Schedule[[Title]:[Title]],Schedule[[End Date]:[End Date]]=(DATEVALUE(B6&"-"&MoMonth&"-"&MoYear)),"-") This formula will automatically spill to as many cells as needed. Because there is now only one category per cell, you can apply conditional formatting rules - one...
Hello.I'm new here and a pretty basic user of excel. I work in print and use Excel to make Datamerge (DM) files in Adobe InDesign. This is a multiple party...