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.
Please Login or Register to view this content.
The result I want is shown below "Goal".
TIA!
Overmyhead,
Tim
In L22, an ordinary formula (Enter):
=IFERROR(INDEX($P:$P, AGGREGATE(15,6, ROW($O$3:$O$300)/($L$21=$O$3:$O$300), ROWS(L$22:L22))),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Glenn,
It works perfectly. Although I was working on column H and not L. (for users looking for a solution in the future)
I should have posted this about 3 hours ago.
Thanks,
Tim
Ah yes... So you were! All sorted though? If not, please shout.
I know what you mean about posting 3hr ago... when I first found this site, I was a total Excel noob.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks