To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...

If you use Microsoft Excel, you probably know the popular spreadsheet tool automatically numbers each row in a spreadsheet outside the columns of the sheet itself. But often you want to have a column ...

With Microsoft Excel's powerful sorting capabilities, you can enter unsorted data and let the software sort your data numerically, alphabetically or chronologically. You can sort all the rows in a ...

It's easy to alphabetize data in a Microsoft Excel spreadsheet by row or column using the "Sort" feature. You can also alphabetize in Excel using shortcuts found in the "Data" or "Home" tabs. One of ...

Office Q&A: How to evaluate the last rows in a changing data set in Excel Your email has been sent TechRepublic member Jeff has an interesting and challenging Microsoft Excel problem: He wants to ...

Q. I know I can sort column information in Excel—by text, numbers and date. But sometimes I need to sort information that’s displayed in a row—not a column. Can I do that without transposing the data?

Please note: This item is from our archives and was published in 2004. It is provided for historical reference. The content may be out of date and links may no longer function. In the September 2003 ...

Rows in an Excel worksheet can be repeated a specified number of times with user-defined functions. The Selection.insert command can be used to insert rows in an Excel sheet and there is no need to ...