Learn how to count the number of unique and distinct values in a column based on data in another column using array in Microsof Excel.

Microsoft Excel is the go-to if you want to calculate a lot of data all at once, but even outside of basic math, you can use the app to find specific info.

If you need to average a list of values in Microsoft Excel that contain duplicates without including the duplicates, don't fret over a complex expression when you can easily remove those duplicates.

The easiest way to spot a unique value is to format it, and Microsoft Excel offers two ways to do so.

Thanks -- and Fool on! The article How to Calculate Intrinsic Values of Shares in Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

You can calculate the T-Value in Excel with the mean, standard deviation and degrees of freedom. Since the T-Value is a comparison between sample mean and population mean, both values need to be ...

Net present value (NPV) is used to estimate the profitability of projects or investments. You can calculate NPV in two ways using Microsoft Excel.

Calculating Nonadjacent Values in Excel Even if you have values that are not in an adjacent cell, you can still calculate them.

Learn what present value (PV) and future value (FV) are and how to calculate present value in Excel given the future value, interest rate, and period.