Columns won't sort correctly

New Contributor

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, @Hans Vogelaar! How did you repair it?

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

@Hans Vogelaar ahh, thanks!