sort data based on date and time priority

[stoey]

Hi everyone,

I am creating a simple leave tracker excel file. I am having difficulty in getting the priority slot when comparing date and time. I tried using Max function but it does not give me the results I need. Attached is a sample file.

Thanks,

stoey

[justinvalle]

By "first slot" I'm guessing you want it sorted so that it's at the top.

I'm not sure how you intended to cause the event so I added a button that triggers the below code, enjoy.

Please Login or Register  to view this content.

[stoey]

Hi Justin,

thank you for your reply...with regards to what you ask:

By "first slot" I'm guessing you want it sorted so that it's at the top.

yeah part of the idea is basically sorting which comes first based on the date and time criteria. I just can't think the appropriate word earlier...anyway, looking back on the test file I uploaded, the upper part which is the input basically should contains the data that are not arranged. on the output area, that is the place where i would like the sorted data to appear but only the first 3 should appear like the example i gave.

thanks,

stoey

[stoey]

an also by the way, can this be done automatically without having to click or place any button? like if all data on the input area were placed, then the sorted first 3 data should appear on the output area. and can this be done also without the use of a macro?

[justinvalle]

Here's a partial:

Please Login or Register  to view this content.

Put that into any cell and it will give you the first entry. The "1" in "= MIN(B6:B10,1)" can be changed to any number to give you that rank -i.e. "2" will give you the second oldest.

Good luck with the rest.

Why no VBA, if you don't mind?