There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

You can filter data in Excel based on either certain parameters in columns or over the whole sheet. When you go to sort data in Excel, specifically when you order your sheet based on a certain set ...

Q. I often recruit Excel to do double duty as a database, and there are times I’d like to reverse the order of numbers or names in a table. How can I do that? A. In other words, you want to take a ...