Last value in column.
 

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:)


--
chew
------------------------------------------------------------------------
chew's Profile: http://www.excelforum.com/member.php...o&userid=33061
View this thread: http://www.excelforum.com/showthread...hreadid=534878

Last value in column.
 

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

HTH
--
AP

"chew" a écrit dans le
message de ...

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:)


--
chew
------------------------------------------------------------------------
chew's Profile:
http://www.excelforum.com/member.php...o&userid=33061
View this thread: http://www.excelforum.com/showthread...hreadid=534878

Last value in column.
 

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" wrote in message
...
=INDEX(B:B,COUNTA(B:B))-B3

HTH
--
AP

"chew" a écrit dans le
message de ...

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:)


--
chew
------------------------------------------------------------------------
chew's Profile:
http://www.excelforum.com/member.php...o&userid=33061
View this thread:
http://www.excelforum.com/showthread...hreadid=534878

Last value in column.
 

Thanks Ardus

Chew


--
chew
------------------------------------------------------------------------
chew's Profile: http://www.excelforum.com/member.php...o&userid=33061
View this thread: http://www.excelforum.com/showthread...hreadid=534878