I am trying to substract the value in the first cell in a column from the
last value in that column using a function, which i can't find.

I want this unknown function to find the last cell with a value in a column
, Not a blank cell, and then substract the first cell from it, it will
probably go like this:

=lastvalue(A:A)-A1