Hi, I am trying to write a formula which shows the difference between the two latest cells of data added in a row. For example, weekly forecasting, I want to see the difference between the current week and previous week (in week 2, the result is week 2 vs week 1, in week 3, the result is week 3 vs week 2...) I've attached an example table; the formula to go into cell G2. I tried using nested IF looking for blank cells but couldn't get it to work. Thanks in advance...
Last edited by jonbadman; 10-14-2022 at 04:20 AM.
One way:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Excellent, thanks for your help
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks