Gurus,
I am building a calendar and trying to figure out what I am doing wrong with multiple events showing up on the same day.
Please see attached file.
on Aug 22, the formula used only sees the first event. I understand why
However, on Aug 23, the formula isn't working as it is not getting any data.
Formula in Cells H22 : H25 was setup as an array.
{=IFERROR(INDEX($P$3:$P$300, SMALL(IF($H$21=$O$3:$O$300, ROW($O$3:$O$300)-MIN(ROW($O$3:$O$300))+1, ""), ROW()-2)),"")}
The result I want is shown below "Goal".
TIA!
Overmyhead,
Tim
Bookmarks