Last value in column.

[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 Petus]

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

HTH

 

[Bob Phillips]

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)

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

HTH

 

[chew]

Thanks Ardus

Chew