Hello,
I have one cell call "Above" and the other one call "Below".
Sometimes, "Above" will change to "Below" and vice versa.
I want to be able to tell how many days since the cell changed from "Above" to "Below"
For example:
Cell A1 change from "Above" to "Below" on day 1------> Cell B1 = 1
Cell A1 stays the same on day 2-------------------------> Cell B1 = 2
Cell A1 stays the same on day 3-------------------------> Cell B1 = 3
Cell A1 change from "Below" to "Above" on day 4------> cell B1 = 1
I have no idea if any formula can do this or will it required some sort of coding? Thanks for your help!
I have one cell call "Above" and the other one call "Below".
Sometimes, "Above" will change to "Below" and vice versa.
I want to be able to tell how many days since the cell changed from "Above" to "Below"
For example:
Cell A1 change from "Above" to "Below" on day 1------> Cell B1 = 1
Cell A1 stays the same on day 2-------------------------> Cell B1 = 2
Cell A1 stays the same on day 3-------------------------> Cell B1 = 3
Cell A1 change from "Below" to "Above" on day 4------> cell B1 = 1
I have no idea if any formula can do this or will it required some sort of coding? Thanks for your help!