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. Returning the top or bottom n ...

I ran into a bit of a roadblock trying to code a program to perform simple matrix operations. The catch was that I wanted to be able to let the user specify the dimension of the matrices on the fly.

Q. I currently keep a static to-do list, and I would like to update it to be more dynamic. Do you have any advice? A. Microsoft Excel is best known for crunching numbers, but it’s also a powerful tool ...