Using Excel, when using the "Sort Ascending" the first and sometimes a few rows don't sort....... Thanks
2006-08-27 13:45:42 · 5 answers · asked by smithw6079 1 in Computers & Internet ➔ Software
make sure you are sorting the same type of data. Also if you are using formulas, the formula could be sorting differently than the cells only containing values. There could also be extra characters such as spaces in the cells that are being sorted, but you don't see them as sorted. Type this formula in another column =trim(Cell number) and drag it down. The copy it and paste it as values. The trim forumula will get rid of any extra characters. Try the sort then.
2006-08-27 14:51:27 · answer #1 · answered by trudy 3 · 0⤊ 0⤋
that's often performed with calculations =sumif(selection of cells with 0's,"0") then repeat for one. Then sum the two totals and divide the completed 0's by making use of the completed for the two solutions. Repeat for the only.
2016-12-14 13:13:01 · answer #2 · answered by ? 3 · 0⤊ 0⤋
I think Excel will not sort a column if the column has empty cells. I don't quite understand it myself.
2006-08-27 13:51:41 · answer #3 · answered by Bryan A 5 · 0⤊ 0⤋
And when you hilight the field you need to sort, deselect "Use Header Row", else, it will not sort it (even if you hilight it).
2006-08-27 13:53:55 · answer #4 · answered by Jose Luis 2 · 0⤊ 0⤋
Are you highlighting all the rows? You have to do that or it will only sort what you highlighted.
2006-08-27 13:48:43 · answer #5 · answered by deepadot 3 · 1⤊ 0⤋