Hi everybody,
normally; C8 cell contains =C7-v45
I want to make a formula that everday automatically subtracts the value of V column(for yesterday) from C7. I tried to use vlookup but some days the value of V column equals zero as you see on table. when the value of V column the day before i want formula to check a cell above if it's contains a different value.
I hope i did explain my question correctly
Attachment 341824
Thanx in advance.
Best Regards
Bookmarks