I'm wondering how to use the sort and filter function in Google sheets to sort in ascending order the following:
1-2 months
2-3 months
3-4 months
...up to 11-12 months
Right now when I sort 1-2months comes first, followed by 11-12 months.
Is there a simple way to sort these fields according to a preset order?
1-2 months
2-3 months
3-4 months
...up to 11-12 months
Right now when I sort 1-2months comes first, followed by 11-12 months.
Is there a simple way to sort these fields according to a preset order?