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