Last value in column.

  • Thread starter Thread starter chew
  • Start date Start date
C

chew

Please could someone tell me how to do this:

Column G has Account Balance (eg. B3 = $100, B2 = $130, B4 = £150
etc.)

I need a formula that will subtract B3 from Bx to show my profit. (Bx
being the last balance entry.)

So when I enter a new balance the profit is automatically updated.

Thanks

Chew:)
 
Ardus,

Might be better as

=INDEX(B:B,COUNT(B:B))-B3

in case there is a text heading in column B.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

Ardus Petus said:
=INDEX(B:B,COUNTA(B:B))-B3

HTH
Click to expand...
 
Back
Top