Auto Date sorting

[ForensicsTJ]

I'm fairly new with excel

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

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

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

Its in Excel 2013, would this make a difference

Georg

+-------------------------------------------------------------------
|Filename: ibu 2.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=608
+-------------------------------------------------------------------

 

[jack_n_bub]

I'm fairly new with excel,

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

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

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

Its in Excel 2013, would this make a difference?

George

Hi,

See attached if it helps.
It was created in Excel 2007 but I don't see a reason why it wouldn'
work in Excel 2013 (Although I am yet to see what it looks like).

Let me know if this doesn't help.

Thanks,
Prashant Kumar Patha

+-------------------------------------------------------------------
|Filename: Check.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=619
+-------------------------------------------------------------------

 

[ForensicsTJ]

Hi,

See attached if it helps.
It was created in Excel 2007 but I don't see a reason why it wouldn'
work in Excel 2013 (Although I am yet to see what it looks like).

Let me know if this doesn't help.

Thanks,
Prashant Kumar Pathak

Thanks for that Prashant, It gave the dates in reverse order ( I wante
nov 2012 before jan 2013) so I changed large for small and it seems t
have worked wonder

+-------------------------------------------------------------------
+-------------------------------------------------------------------