Forum Discussion
Columns won't sort correctly
Hi, For the District Analysis tab on the attached spreadsheet, I am trying to sort the numerical columns lowest to highest or vice versa but they are not sorting correctly. Any ideas why that's happ...
KMEAGHER It looks like some columns have been sorted without allowing the other columns to be sorted with them. In the attached version, I have repaired this.
If you want to sort, for example on column C, select a single cell in that column, for example C2. Do not select the entire column. Then click Sort & Filter > Sort Smallest to Largest.
- Thank you, HansVogelaar! How did you repair it?
I edited the formulas in row 2 to refer to cell A2.
Then, I filled the formulas from row 2 down to the last row.
- HansVogelaar ahh, thanks!
