How to return the top or bottom n records without a filter or PivotTable in Excel Your email has been sent Returning the top or bottom n records of a data set in Excel isn’t difficult, and there are ...

In addition to the new SORT function, you may also find the new FILTER and UNIQUE array functions useful. For example, the worksheet on the next page contains a detailed listing of invoices in columns ...

To make the most of the UNIQUE function, you should make sure your array is in an Excel table. By using a table name rather ...

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

A language that's data-intensive naturally should have a way to dig into the data effectively. Here's a look at some of the R functions for searching and sorting through it all. Searching and sorting ...

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code. You are probably familiar ...

Reshaping a two-dimensional array of data into a single column or row in Microsoft Excel streamlines the layout of your figures and makes for more efficient sorting and filtering. For these reasons, ...

Anyone who has taken a basic computer science class has undoubtedly spent time devising a sorting algorithm—code that will take an unordered list of items and put them in ascending or descending order ...

Selective trafficking of membrane proteins to lysosomes for destruction is required for proper cell signalling and metabolism. Ubiquitylation aids this process by specifying which proteins should be ...