It will take a combination of five different functions to get the number of unique values in a column. Which functions you use depends on what values are being counted.

How to Display a Count of Cells on the Bottom of the Window in Excel. Numbers affect your business's success, and Excel helps you manage your numbers. Whether your spreadsheets contain sales ...

Microsoft Excel allows you to crunch massive quantities of data easily through the use of functions. Sometimes you need to know the number of actual data points without counting blank cells. As an ...