Hello all,
I am trying to figure out a formula for this situation. The sample I provided here is just for two accounts with a few months.
My formula would be need to follow these criterias:
1) Need to be same account (column A)
2) Previous MV (i.e. Column D3) - Current MV (i.e. Column C2)
The result I want is in Column E but you can see it is not working because it is not using the same account at certain row when a new account starts (i.e. Row 6). My actual data are thousand of accounts and 5 years (monthly) of rows. Thank you in advance for helping with my question/challenge.
Bookmarks