Improving formula
 

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.

Improving formula
 

I think your formula is pretty effective


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com






"Brad" wrote in message
...
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.