Excel’s UNIQUE() function returns a list of unique names. UNIQUE()retrieves the unique values and passes them to SORT(), which returns them in alphabetical order.

Excel's HLOOKUP (Horizontal Lookup) function can search for a value in the first row of a table and then return a value in the same column from a row you specify.

Learn how to combine Microsoft Excel’s ROW() and ROUNDUP() functions to create a flexible serial function that returns groups of consecutive values.

What Is the TRIMRANGE Function? Imagine you just imported a dataset into Excel and noticed that there are several empty rows and columns in the range. They're making the sheet mes ...

Functions in all categories share a common set of data types such as number, text, date and Boolean. Each function accepts one or more parameters of a given type and returns a value of a given type.

Example A: Your client would like to contribute $12,000 to a retirement account at the beginning of each year for the next 20 years, earning an annual return of 6%. The formula in cell B13 in the ...

As a long-term Excel enthusiast, I have always enjoyed using VLOOKUP, one of Excel's best-known lookup functions. However, ...

We would still like to identify unique customers from the transaction log by entering my formula one time, and Excel returns the customers’ names. We have a couple of options on how these names are ...

3] NPV. The NPV function returns the net present value of an investment based on a series of periodic cash flows and a discount rate. The formula for the NPV function is NPV(rate, value 1,[value2 ...

How to Calculate NPV in Excel Using XNPV Function . To calculate the NPV of an investment project, you must consider the present value of all cash receipts and all cash disbursements related to ...