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 column ...

Duplicates aren’t bad, but you may need to know how many times a value is repeated or how many unique values are in a data range. Here’s how to tackle these tasks in Excel. Counting duplicate values ...