Auto Date sorting

F

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
+-------------------------------------------------------------------
 
J

jack_n_bub

ForensicsTJ;1605987 said:
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
+-------------------------------------------------------------------
 
F

ForensicsTJ

jack_n_bub;1606311 said:
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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top