Search bottom to top of a column to displaying all results that match a criteria

Well the problem is that the date information you want to sort off of is only inside the end of a text string, so in order to sort, you'll have to pull that out, parse into date, and then repackage.

If you're getting the data populated by a dump from some external data, what's your appetite to change that macro so it populates a table with POV-xxx, Start_Date, and Finish_Date? Then you could just use regular sort/filter to filter out blank Finish_Date and sort any way you want without having to mess with formula.

One way:
=LET(r,B2:B21,sr,SORTBY(r,ROW(r),-1),FILTER(sr,ISNUMBER(SEARCH("Finished",sr))))

=LET(r,B2:B21,sr,SORTBY(r,ROW(r),-1),FILTER(sr,ISNUMBER(SEARCH("Finished",sr))))

Red - defines r as being the range.
Orange - defines sr as the rows sorted by row number (in descending order - the -1)
Green: returns the rows that contain the word "finished"
Black filters sr, only returning those rows that contain "Finished".

To change the range, you only need to change the B2:b21 bit.

Re GS> Never used them, but Excel does not accept B2:B as a valid range. It needs a defined start and end point. B2:B21 HAS a defined end point.


You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

Wow Glenn Kennedy, I'm not sure a thank you is enough because you are actually a hero. I have been searching for this for so long and what you wrote works like a charm, plus you solved it in under 1 day so I'm truly in awe of you excel skills. Thanks again for helping me. (Also cheers for the added comment about Google Sheets)

Thanks also for the description of reputation and marking a thread as solved, I was very keen to do both because your solution helped me so much. I have therefore just added some reputation for your unbelievably amazing solution and have also marked the thread as solved. I honestly appreciate your time so thank you very much.