Excel's ascending and descending sort options are powerful tools, but they won't always sort values in a familiar and meaningful way. When this is the case, you might need a custom sort. Sorting is a ...

You can use Microsoft Excel to set up a simple row-and-column matrix of information, listing income data, itemizing expenses and documenting events. These tasks barely scratch the surface of Excel's ...

Sorts are a simple task in Microsoft Excel if all you need is an ascending or descending sort. Excel is smart enough that it can interpret the data range. Not all sorts are so easy. Fortunately, Excel ...

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 ...

Let’s check out these steps in detail. Open the spreadsheet with Microsoft Excel on your computer. After that, you should see a column containing all the dates. You need to select all the cells that ...

One of the biggest pains of using a PC is rooting around the file system to find very specific information. Over the years, Microsoft has made it easier to find files with enhanced search capabilities ...

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 ...

After spending several months adding customer data to your Excel spreadsheets, they are probably going to become extremely long. Searching through them will become quite a chore. Rather than waste a ...