Hello there,
I need help. I am NOT an excel wizzard and have a complex issue I need help with. :(
I have an excel data sheet where I enter campaign ad data. Main fields in columns are:
a). Type Ad (options: Special Offer,
House Ad, Paid Ad)
b). Ad Slot (Slot 1, Slot 2, Slot 3, Slot 4)
c). Start Date, End Date (dates are sometimes duplicates and overlap)
d). Offer Details (Campaign Name)
I want to pull in the "offer details" into a calendar view in the next sheet based on the calendar date. So basically populate the calendar with all the ads running on that date.
I have tried lookups but since there are date range duplicates and no specific id I can't seem to get it right. Can someone help? I have a spreadsheet available to share if any of this is unclear.
Thanks much in advance.
AC
I need help. I am NOT an excel wizzard and have a complex issue I need help with. :(
I have an excel data sheet where I enter campaign ad data. Main fields in columns are:
a). Type Ad (options: Special Offer,
House Ad, Paid Ad)
b). Ad Slot (Slot 1, Slot 2, Slot 3, Slot 4)
c). Start Date, End Date (dates are sometimes duplicates and overlap)
d). Offer Details (Campaign Name)
I want to pull in the "offer details" into a calendar view in the next sheet based on the calendar date. So basically populate the calendar with all the ads running on that date.
I have tried lookups but since there are date range duplicates and no specific id I can't seem to get it right. Can someone help? I have a spreadsheet available to share if any of this is unclear.
Thanks much in advance.
AC
Comment