Columns won't sort correctly

[KMEAGHER]

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 

[#2]

@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.

[#3]

Thank you, @Hans Vogelaar! How did you repair it?

[#4]

@KMEAGHER 

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.

[#5]

@Hans Vogelaar ahh, thanks!