Hi Team,
I am trying to find the difference of. rows 1 & 2 in the last row (Delta) with multi row formula.
Name | Sales |
Anton | 265028.7253 |
Xavier | 251141.7401 |
Delta |
I am unable to see Row-2 in the multi row formula to update the formula as
if [ Name ]="Delta" then ([Row-2:Sales]- [Row-1:Sales])
else [Sales]
endif
Am i missing something.?
Can you pls. assist.
Thanks
SS
Solved! Go to Solution.
Thanks @danilang