Discuss how to increment value in one cell in Excel if another cell is populated.
For example, I have cell A that has values such as 1, 2, 3, 4 etc...but I want to be able to check cell A and if there is a value present, increment cell B by 1 each time. I would like a macro to do this or formula.