Updating a count every time a value is changed
Posted by Dan on July 11, 2001 8:33 AM
I'm trying to have a cell with a starting value of "0" that will increase every time another refrenced cell is changed. For example, Cell A1 is a TRUE/FALSE value, and I want Cell A2 to count how many times Cell A1 has changed between true and false. I've racked my brain trying to come up with ways to do this, even looking into macros and user-defined functions, and am having trouble. Does anyone have any suggestions? Your help would be greatly appreciated.