Is it possible to have a formula that will calculate difference from one cell to another cell in the same column? Basically I’m just subtracting A1-a30, A2-A30, A3-A30, etc. and putting the value in B1, B2, B3, etc.)
Thanks for the response. Can you point me to a tutorial where I can return value X from a record based on a rollup (or formula) finding the max of value Y? I thought maybe FIND(MAX(),{Date},{Number}) would do it but that not right. I’m just trying t...
Ok, so I found out how to group the records by month, but now I’m having trouble doing the calculation of the current cell from the last cell in that group. Basically, Any idea how to reference the last row in the current group so the formula would l...
