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
--
AP

"chew" <[email protected]> a écrit dans le
message de news:[email protected]...
>
> 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
>

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

"Ardus Petus" <[email protected]> wrote in message
news:[email protected]...
> =INDEX(B:B,COUNTA(B:B))-B3
>
> HTH
> --
> AP
>
> "chew" <[email protected]> a écrit dans le
> message de news:[email protected]...
> >
> > 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
> >
>
>

[chew]

Thanks Ardus

Chew