Sheets: Filter and sort list based on date/time

I am working with the following table in Google Sheets:

Table.png

What I am trying to do is sort the names ("PERSON") by date/time from least recent to most recent, excluding any name whose status is marked "Reserve." I would like the resulting list to appear in a new column with no blank rows between names.

The goal is that a user should be able to update the timestamp without doing anything else and that will created an updated, organized list of non-reserve people in a fourth column.

I would very much appreciate any help you can provide. Thank you!

Hi there.


1. Is this a Googlesheets question, or Excel, or what? (You posted in the "other platforms" sub-forum).

2. A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

3. Excel 2022?? Is there one? Please verify your Excel PRODUCT and update your profile.

Sorry, this is for Google Sheets. Clarified in the post and title.

I don't currently have a worksheet available, as I am not on my work machine, which is why I posted a photo. I was hoping this solution might be simple enough that it wouldn't require a worksheet.

I'm out, I never use GS.

However, the way the forum works is that we offer help for free. We do it only for the fun of it (yes... it is a bit sad...).

In return we expect YOU to do the groundwork (sample sheets, decent explanation, etc) so that we do not have to recreate what you ALREADY have right in front of you...

Others who do use GS will be along sooner or later...

dduhamel welcome to the forum.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Thank you in advance.