I’m doing a mileage spreadsheet for my car,
In cell A1 heading = Mileage in cell A2 value = 50000 In cell A3 value = 50100 In cell A4 value = 50200 ..and so on
Difference amount goes into Cell B2
So in this case B2 = 200 (A4-A2)
Without knowing how many entries will be introduced in column A (could be 10 or could be 110 entries) How can I ask calc to calculate the difference between the last entry in Column A and the first Entry in Column A (A2)
So Basically I just want to subtract the first entry from the last current entry In Column A with out out knowing how many entries there might be using an array formula.
Thanks again for the help