Count how many times a cell changes value

[danielpt78]

Hi All,

Is there anyway I can count how many times a cell has a specific value? I would like to have an increment counting for example, everytime the cell A2 gets to "2" the cell "B2" would increase its value +1 and so on, starting from zero.

Thanks for the help!

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Count how many times a cell changes value
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.