Originally Posted by ForensicsTJ

I'm fairly new with excel,

To anyone with any suggestions, attached is a small sample of my spreadsheet.

On it is a list of events with accompanying dates, as seen not all events have dates.

Is it possible to compile in columns J a list of events with accompanying dates in column K in date order (for the M data column), so that if a date or event should change or be added the list automatically adjusts for this change (if that makes any sense)?

Its in Excel 2013, would this make a difference?

George