Hi guys,
I have attached the example. The thing is I need to find a function which could be used to subtract values from one row (any of the cells in the selected range) from the row below (any of the cells).
E.g. A1 (1) B1(BLANK) C1(BLANK)
A2(BLANK) B2 (3) C2(BLANK)
in this case I would want to subtract B2 from A1
but combinations vary from row to row (A1-A2;B1-A2;C1-A2...A1-B2;B1-B2;C1-B2...C1-C2;B1-C2; ) the only thing that is consistent is that it's always only one non blank cell in the row
I have tried using functions for one cell and just applying it to the range that I have used and it doesn't work
Please help
Bookmarks