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

Find the data you need in an Excel sheet more easily with these functions.

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

Use this combination of Excel functions to find the latest date and return a corresponding value.

This tutorial will explain how to find a value in an Excel column using the Find function in VBA.

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.