When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.

There are a few ways to count the number of items in an Excel list, depending on the data you have. One way is using the COUNTIF function.

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

How to Insert a Return in an MS Excel Cell. The "Enter" key or "Return" key on your keyboard doesn't always work the same way in Microsoft Excel as it does in many other programs, where pressing ...

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

Calculating the return One of the best methods for calculating an average return for a stock investment is the XIRR function in Excel.