Excel – Sorting Huge Lists of Data in a Spreadsheet in Excel
Sorting data in Excel is a common task you may perform all the time. It is possible to sort a list and find out the data didn’t sort exactly how you thought it would. There are three common reasons as to why your data won’t sort properly. One of the reasons could be that the list is just too large and you don’t have enough memory on your computer to perform the sort. The other two reasons are shown in detail in this tutorial. This will work in Excel 2003, Excel 2007 and Excel 2010.