0

In Google Sheets, I'm using a query to pull all my data from different tabs into one master sheet. And now I'm wondering how to sort the data according to a preset order. The order I want to sort to is something like this:

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?

Improve this question
6
  • That sort of sort indicates that you are doing it on textual values. With no other (and better) specifications about your file I can only recommend you name them: 01-02 months 02-03 months 03-04 months ... up to 11-12 months
    – Daniele
    Aug 15, 2022 at 6:58
  • Does this answer your question? How to sort cells with text and numbers correctly
    – Tedinoz
    Aug 15, 2022 at 11:39
  • I'm not sure how to properly adapt the formula to make it work. It shows up a 'Formula Parse Error'
    – JW2022
    Aug 16, 2022 at 7:44
  • share your experience with us, post the link to your file
    – Daniele
    Aug 16, 2022 at 16:10
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Aug 17, 2022 at 0:06

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.