is a senior editor and author of Notepad, who has been covering all things Microsoft, PC, and tech for over 20 years. Microsoft Excel used to only allow two types of data: text and numbers. After ...

The SORT and SORTBY functions let you extract certain columns and rows from a dataset and sort them in a certain order, all while preserving the source data. Even though they work in similar ways, ...