Hi,
I have some data from two drop-down lists that I would like to sort.
The data is in two columns
1: 'Day of the week'
and
2: 'Time'
I would like to be able to sort the drop-down data so that
it is in order of days then timeslots - eg, all the Mondays in time order, followed by all the Tuesdays in time order etc.
Is this possible?
I've tried using a filter but it puts Thursday before Tuesday and doesn't always get the other days in order either.
Not sure how to solve this?
Any suggestions would be welcomed,
kind regards,
MJ
Here is a link to the sheet:
I have some data from two drop-down lists that I would like to sort.
The data is in two columns
1: 'Day of the week'
and
2: 'Time'
I would like to be able to sort the drop-down data so that
it is in order of days then timeslots - eg, all the Mondays in time order, followed by all the Tuesdays in time order etc.
Is this possible?
I've tried using a filter but it puts Thursday before Tuesday and doesn't always get the other days in order either.
Not sure how to solve this?
Any suggestions would be welcomed,
kind regards,
MJ
Here is a link to the sheet:
Days and Time slots
Sheet1 DAY OF WEEK,TIME Wednesday,20:30 - 21:20 Wednesday,14:30 - 15:20 Tuesday,12:30 - 13:20 Tuesday,09:30 - 10:20 Thursday,11:30 - 12:20 Thursday,18:30 - 19:20 Sunday,16:30 - 17:20 Saturday,14:30 - 15:20 Monday,11:30 - 12:20 Monday,17:30 - 18:20 Friday,10:30 - 11:20 Friday,12:30 - 13:20 Friday...
docs.google.com