If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.

Specifying the conditional count of a value sounds like a daunting task, but two Excel functions make quick work of this challenge.

If you use Microsoft Excel, you probably know the popular spreadsheet tool automatically numbers each row in a spreadsheet outside the columns of the sheet itself. But often you want to have a ...

If you have a lengthy column of numbers that you need to multiply by a percentage, Excel includes tools to instantly apply the product to the entire range of cells in the column.

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.