How to Increment a Number in Excel. Product IDs, serial numbers and other reference numbers require a unique identifier to avoid confusion when referencing a product or specific data point.

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

Susan Harkins shows you how to format and unlock input cells in Excel at the same time by assigning a modified style.