Complex Date Mapping, Ordering, and Selection Formula Help

Hello,

I have a very difficult (to me at least) formula to work out.

Here is the setup:

Each cell in Column A contains a discrete piece of data that is an action item.

Each cell in Column B contains data that may opr may not include a date or dates that describes the data in the Column A cell in the same row. Basically, the Column B cells are due dates and notes for the Column A cells. Some of the cells in Column B contain the same date (e.g., 12/31/2012 appears alot).

Essentially, I want to create a calendar. This would be a list of every date in Column B, arranged sequentially. Each date should be followed by the contents of every cell to which it refers. So, for example, if the Column B cells that correspond to Column A, cells 1, 7, and 9 each contain 12/31/2012, then when 12/31/2012 appears on the calendar list it should state "12/31/2012: 1,7,9"

Any ideas how to make this happen?

I've included a sample sheet.

Thanks,

Hi MinMn,

Please take a moment to review the forum rules and then amend your thread title to something descriptive of your issue. Once you have done this please PM me and I will remove this request.

Also, everyone here is a volunteer, so questions aren't always answered on-demand. If that's the service you need, perhaps a consultant is required.