Modify Macro to search columns before rows

Good Afternoon

I have a macro in the attached spread sheet which is fab and works like a dream, I just need it to search columns before rows (default I guess). It may be that somebody has booked an appointment at 11am on Tuesday and also at 4pm on Monday (see Client X in the sheet. At the moment the returning list would put Tuesday before Friday but I'd like it the other way around.

Sadly I can't just sort the list by date as often the returned text is not formatted as a date.

Many thanks in advance

Thank you both, I will give these a go