Need formula for a fixed cell minus last entry on ongoing log

Hi Mari

Say your first entry is in C2, then in D3 enter =IF(C3="","",$C$2-C3) and
copy down as far as you want to go. You will then always subtract the last
entry from the first one, so that in D20, the formula will subtract C20 from
C2.

However, if you want the difference between the last 2 entries every time,
then enter in D3 =IF(C3="","",C2-C3) and copy down. In this case in row 20
the formula will subtract C20 from C19.

"Mari C" wrote:

> Hi all - I need a formula so that I get the difference between the first
> entry and the last entry - an ongoing log. How do I do that
>
> thanks
>
> Mari

Hi!

First entry in A1.

Last entry in An

=A1-LOOKUP(9.99999999E+307,A:A)

Biff

"Mari C" <Mari [email protected]> wrote in message
news:[email protected]...
> Hi all - I need a formula so that I get the difference between the first
> entry and the last entry - an ongoing log. How do I do that
>
> thanks
>
> Mari

Thanks biff - after I limited the size of the column I was able to enter it
in the bottom of the column
Mari

"Biff" wrote:

> Hi!
>
> First entry in A1.
>
> Last entry in An
>
> =A1-LOOKUP(9.99999999E+307,A:A)
>
> Biff
>
> "Mari C" <Mari [email protected]> wrote in message
> news:[email protected]...
> > Hi all - I need a formula so that I get the difference between the first
> > entry and the last entry - an ongoing log. How do I do that
> >
> > thanks
> >
> > Mari
>
>
>

Hi Kassie

I needed to enter 20 columns so I wanted the sum at the bottom of the column
- biffs formula worked better for the layout of the page but yours was great
too. thanks a bunch

"Kassie" wrote:

> Hi Mari
>
> Say your first entry is in C2, then in D3 enter =IF(C3="","",$C$2-C3) and
> copy down as far as you want to go. You will then always subtract the last
> entry from the first one, so that in D20, the formula will subtract C20 from
> C2.
>
> However, if you want the difference between the last 2 entries every time,
> then enter in D3 =IF(C3="","",C2-C3) and copy down. In this case in row 20
> the formula will subtract C20 from C19.
>
> "Mari C" wrote:
>
> > Hi all - I need a formula so that I get the difference between the first
> > entry and the last entry - an ongoing log. How do I do that
> >
> > thanks
> >
> > Mari

You're welcome. Thanks for the feedback!

Biff

"Mari C" <[email protected]> wrote in message
news:[email protected]...
> Thanks biff - after I limited the size of the column I was able to enter
> it
> in the bottom of the column
> Mari
>
> "Biff" wrote:
>
>> Hi!
>>
>> First entry in A1.
>>
>> Last entry in An
>>
>> =A1-LOOKUP(9.99999999E+307,A:A)
>>
>> Biff
>>
>> "Mari C" <Mari [email protected]> wrote in message
>> news:[email protected]...
>> > Hi all - I need a formula so that I get the difference between the
>> > first
>> > entry and the last entry - an ongoing log. How do I do that
>> >
>> > thanks
>> >
>> > Mari
>>
>>
>>

Hi Mari

Say your first entry is in C2, then in D3 enter =IF(C3="","",$C$2-C3) and
copy down as far as you want to go. You will then always subtract the last
entry from the first one, so that in D20, the formula will subtract C20 from
C2.

However, if you want the difference between the last 2 entries every time,
then enter in D3 =IF(C3="","",C2-C3) and copy down. In this case in row 20
the formula will subtract C20 from C19.

"Mari C" wrote:

> Hi all - I need a formula so that I get the difference between the first
> entry and the last entry - an ongoing log. How do I do that
>
> thanks
>
> Mari

Hi!

First entry in A1.

Last entry in An

=A1-LOOKUP(9.99999999E+307,A:A)

Biff

"Mari C" <Mari [email protected]> wrote in message
news:[email protected]...
> Hi all - I need a formula so that I get the difference between the first
> entry and the last entry - an ongoing log. How do I do that
>
> thanks
>
> Mari

Thanks biff - after I limited the size of the column I was able to enter it
in the bottom of the column
Mari

"Biff" wrote:

> Hi!
>
> First entry in A1.
>
> Last entry in An
>
> =A1-LOOKUP(9.99999999E+307,A:A)
>
> Biff
>
> "Mari C" <Mari [email protected]> wrote in message
> news:[email protected]...
> > Hi all - I need a formula so that I get the difference between the first
> > entry and the last entry - an ongoing log. How do I do that
> >
> > thanks
> >
> > Mari
>
>
>

Hi Kassie

I needed to enter 20 columns so I wanted the sum at the bottom of the column
- biffs formula worked better for the layout of the page but yours was great
too. thanks a bunch

"Kassie" wrote:

> Hi Mari
>
> Say your first entry is in C2, then in D3 enter =IF(C3="","",$C$2-C3) and
> copy down as far as you want to go. You will then always subtract the last
> entry from the first one, so that in D20, the formula will subtract C20 from
> C2.
>
> However, if you want the difference between the last 2 entries every time,
> then enter in D3 =IF(C3="","",C2-C3) and copy down. In this case in row 20
> the formula will subtract C20 from C19.
>
> "Mari C" wrote:
>
> > Hi all - I need a formula so that I get the difference between the first
> > entry and the last entry - an ongoing log. How do I do that
> >
> > thanks
> >
> > Mari

You're welcome. Thanks for the feedback!

Biff

"Mari C" <[email protected]> wrote in message
news:[email protected]...
> Thanks biff - after I limited the size of the column I was able to enter
> it
> in the bottom of the column
> Mari
>
> "Biff" wrote:
>
>> Hi!
>>
>> First entry in A1.
>>
>> Last entry in An
>>
>> =A1-LOOKUP(9.99999999E+307,A:A)
>>
>> Biff
>>
>> "Mari C" <Mari [email protected]> wrote in message
>> news:[email protected]...
>> > Hi all - I need a formula so that I get the difference between the
>> > first
>> > entry and the last entry - an ongoing log. How do I do that
>> >
>> > thanks
>> >
>> > Mari
>>
>>
>>

Hi all - I need a formula so that I get the difference between the first
entry and the last entry - an ongoing log. How do I do that

thanks

Mari

Hi Mari

Say your first entry is in C2, then in D3 enter =IF(C3="","",$C$2-C3) and
copy down as far as you want to go. You will then always subtract the last
entry from the first one, so that in D20, the formula will subtract C20 from
C2.

However, if you want the difference between the last 2 entries every time,
then enter in D3 =IF(C3="","",C2-C3) and copy down. In this case in row 20
the formula will subtract C20 from C19.

"Mari C" wrote:

> Hi all - I need a formula so that I get the difference between the first
> entry and the last entry - an ongoing log. How do I do that
>
> thanks
>
> Mari

Hi!

First entry in A1.

Last entry in An

=A1-LOOKUP(9.99999999E+307,A:A)

Biff

"Mari C" <Mari [email protected]> wrote in message
news:[email protected]...
> Hi all - I need a formula so that I get the difference between the first
> entry and the last entry - an ongoing log. How do I do that
>
> thanks
>
> Mari

Thanks biff - after I limited the size of the column I was able to enter it
in the bottom of the column
Mari

"Biff" wrote:

> Hi!
>
> First entry in A1.
>
> Last entry in An
>
> =A1-LOOKUP(9.99999999E+307,A:A)
>
> Biff
>
> "Mari C" <Mari [email protected]> wrote in message
> news:[email protected]...
> > Hi all - I need a formula so that I get the difference between the first
> > entry and the last entry - an ongoing log. How do I do that
> >
> > thanks
> >
> > Mari
>
>
>

Hi Kassie

I needed to enter 20 columns so I wanted the sum at the bottom of the column
- biffs formula worked better for the layout of the page but yours was great
too. thanks a bunch

"Kassie" wrote:

> Hi Mari
>
> Say your first entry is in C2, then in D3 enter =IF(C3="","",$C$2-C3) and
> copy down as far as you want to go. You will then always subtract the last
> entry from the first one, so that in D20, the formula will subtract C20 from
> C2.
>
> However, if you want the difference between the last 2 entries every time,
> then enter in D3 =IF(C3="","",C2-C3) and copy down. In this case in row 20
> the formula will subtract C20 from C19.
>
> "Mari C" wrote:
>
> > Hi all - I need a formula so that I get the difference between the first
> > entry and the last entry - an ongoing log. How do I do that
> >
> > thanks
> >
> > Mari

You're welcome. Thanks for the feedback!

Biff

"Mari C" <[email protected]> wrote in message
news:[email protected]...
> Thanks biff - after I limited the size of the column I was able to enter
> it
> in the bottom of the column
> Mari
>
> "Biff" wrote:
>
>> Hi!
>>
>> First entry in A1.
>>
>> Last entry in An
>>
>> =A1-LOOKUP(9.99999999E+307,A:A)
>>
>> Biff
>>
>> "Mari C" <Mari [email protected]> wrote in message
>> news:[email protected]...
>> > Hi all - I need a formula so that I get the difference between the
>> > first
>> > entry and the last entry - an ongoing log. How do I do that
>> >
>> > thanks
>> >
>> > Mari
>>
>>
>>