I have some textual data in a Calc spreadsheet in Sheet1. It is referenced on another sheet.
Having re-ordered the data on Sheet1, the sort order on the other sheet now looks something like this:
=$Sheet1.A2 =$Sheet1.A3 =$Sheet1.A6 =$Sheet1.A1 =$Sheet1.A5 =$Sheet1.A4
When I try to use the
Data > Sort options, it will only offer me an alphabetical sort of the content, NOT a sort on the cell numbers (A1, A2, A3, etc.).
Question: Is there a way to make Calc sort these cells on the value of the cell number, rather than an alpha sort of the referenced content? I live in hope!
I have looked at these Q&As without working out my question, so perhaps I’m missing something: