Is there any other formula instead of OFFSET?
Because Excel prompts to save every time I close it even if I don't change anything.
Here's my formula: G5=OFFSET(G5,-1,0)+F5-E5
And if I use this formula, auto-update won't work in table: G5=G4+F5-E5
Because Excel prompts to save every time I close it even if I don't change anything.
Here's my formula: G5=OFFSET(G5,-1,0)+F5-E5
And if I use this formula, auto-update won't work in table: G5=G4+F5-E5