08-09-2020 11:19 PM
I have a cell whose values changes on daily basis because of the changes different departments make in the source sheet. I want to know how much the cell value has increased or decreased on a daily basis - the net change in the value of that cell. In other words, I want to subtract yesterday's value of that cell from its today's (latest) value and return the difference in another cell.
Please help me with the formula to do this. Thanks a lot.
08-10-2020 12:54 AM
Maybe through this information first determine the change and then the desired mean value with a formula ... is just one thought.
https://docs.microsoft.com/en-gb/office/troubleshoot/excel/run-macro-cells-change
I would be happy to know if I could help.
Nikolino
I know that I don't know (Socrates)
08-24-2020 10:18 PM
08-24-2020 10:30 PM