Apr 20 2021 09:11 AM
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
Apr 20 2021 09:25 AM - edited Apr 20 2021 09:26 AM
@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.
Apr 20 2021 09:30 AM
Apr 20 2021 09:44 AM
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.