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

It creates a reusable function that takes three inputs: actual sales, sales quota, and a weighting factor. It returns a ...

How to generate random numbers with no duplicates in Excel Your email has been sent Over the last few months, I’ve written about several of Excel’s new dynamic array functions. They’re powerful and ...

Microsoft has been adding new features to Excel lately, and the latest one could change the way people work with formulas.

An curved arrow pointing right. {} These brackets mean something magical is happening inside your Excel formula. An "Array" function allows you to perform mathematical operations on many cells instead ...

Excel's VLOOKUP function searches cell arrays for data that you provide. The function often takes cell references as input, letting you easily apply the function to each cell in a range. Alternatively ...

Microsoft has announced some improvements to the way formulas work in Microsoft Excel, introducing a new capability called Dynamic Arrays, which was first announced last year, but only available to a ...

These new Excel features for working with text and lists will save you time Your email has been sent One of the reasons Microsoft Excel is so popular for so many tasks that aren’t necessarily ...

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...

Microsoft Excel 2010 comes with the latest version of Visual Basic for Applications, or VBA, which is a programming language designed to interface easily with Microsoft Office products. VBA allows you ...