Hello everyone,
i have a calendar that is a table and i would like to place the values in a formatted table
Tab:
Event Booking , is where we place the events in a linear way, one after the other
Event Overview, is where i would like to place the Event Name from Event Booking
Please let me know if my explanation is not clear
Please try at B4
=IFERROR(INDEX(Table4,AGGREGATE(15,6,ROW(Table4)/(INDEX(Table4,,2)=B$3),ROWS(B$4:B4))-ROW(Table4[#Headers]),3),"")
Hey Bo_ry
thank you for the file but there is a small issue.
i need the name to appear according to the number, so if in sheet "Event Booking" it''s on the 29th then in "Event Overview" it should be in the cell"B32"
if it makes it easier, i can make sure that in Event Booking, one row, one date.
How about B4 one Event per day
=IFERROR(INDEX(Table4,AGGREGATE(15,6,ROW(Table4)/(INDEX(Table4,,1)=--($A4&B$3)),1)-ROW(Table4[#Headers]),3),"")
On the same date more than one events are there. should all of them appear in one cell of Event Overview sheet.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks