Forum Discussion
KMEAGHER
Apr 20, 2021Copper Contributor
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...
HansVogelaar
Apr 20, 2021MVP
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.
KMEAGHER
Apr 20, 2021Copper Contributor
Thank you, HansVogelaar! How did you repair it?