Forum Discussion
Excel not sorting numbers correctly - smallest to largest etc.
Not sure if anyone else has come into issues, I was attempting to use the =CLEAN formula to fix my own spreadsheet, but it was acting wonky when I tried to insert a row. I realized that my table did not extend further.
So if anyone else is working in a table they've set up in excel, you may have to check on the size of your table. a column wasn't ordering properly because a set of the cells were not in the table. I resized the table down further and it fixed the issue immediately 🙂
I didn't import data. It says 55 is bigger than 60 and 37 is bigger than 40. I calculated sums across columns. I decided to copy and paste values, so there wouldn't be any calculations. Stilll in the same order. What is the point of having excel if it can't do basic math? I don,t understand why I have to make it more complicated and look up the =clean function for a list of 80 names and numbers to be sorted correctly.