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 happening?
Thanks!
Kevin
4 Replies
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.
