Improving formula

[Brad]

Everyday a new line of data is added to the bottom of a report. What has to
be done, in a summary report (found on a different tab) is to subtract
yesterday's value from today's value.

The equation below works - however I would like to know if there is a better
one.

=INDEX('Running total'!G21:G1040,COUNT('Running
total'!G21:G1040))-INDEX('Running total'!G21:G1040,COUNT('Running
total'!G21:G1040)-1)

Right now the data goes to about row 200.

Thanks in advance.

[Peo Sjoblom]

I think your formula is pretty effective


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com






"Brad" <Brad@discussions.microsoft.com> wrote in message
news:16361D18-7C08-4AC1-A36B-58D0120D5C2D@microsoft.com...
> Everyday a new line of data is added to the bottom of a report. What has
> to
> be done, in a summary report (found on a different tab) is to subtract
> yesterday's value from today's value.
>
> The equation below works - however I would like to know if there is a
> better
> one.
>
> =INDEX('Running total'!G21:G1040,COUNT('Running
> total'!G21:G1040))-INDEX('Running total'!G21:G1040,COUNT('Running
> total'!G21:G1040)-1)
>
> Right now the data goes to about row 200.
>
> Thanks in advance.