Find last number

[MamaBee]

Hello.
This Excel beginner could use your help.

I would like to have cell g3 display the last number added to range
B2:B76.

Any help is appreciated.
TIA
MamaB

[Paul B]

MamaBee, here is one way,

=INDEX(B2:B76,MATCH(9.99999999999999E+307,B2:B76))
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"MamaBee" <[email protected]> wrote in message
news:[email protected]...
> Hello.
> This Excel beginner could use your help.
>
> I would like to have cell g3 display the last number added to range
> B2:B76.
>
> Any help is appreciated.
> TIA
> MamaB
>

[Gord Dibben]

In G3 enter =LOOKUP(9.99999999999999E+307,B2:B76)


Gord Dibben MS Excel MVP


On Thu, 03 Aug 2006 14:42:34 GMT, MamaBee <[email protected]> wrote:

>Hello.
>This Excel beginner could use your help.
>
>I would like to have cell g3 display the last number added to range
>B2:B76.
>
>Any help is appreciated.
>TIA
>MamaB

[RagDyeR]

Try this:

=LOOKUP(99^99,B2:B76)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"MamaBee" <[email protected]> wrote in message
news:[email protected]...
Hello.
This Excel beginner could use your help.

I would like to have cell g3 display the last number added to range
B2:B76.

Any help is appreciated.
TIA
MamaB

[MamaBee]

THANKS, Gord and others who responded; much appreciated.

Thanks to this group, I'm learning lots about Excel ...... don't always
understand the reasoning behind some of the formulas but I'm learning.
MamaBee

Gord Dibben wrote:

> In G3 enter =LOOKUP(9.99999999999999E+307,B2:B76)
>
>
> Gord Dibben MS Excel MVP
>
>
> On Thu, 03 Aug 2006 14:42:34 GMT, MamaBee <[email protected]> wrote:
>
>
>>Hello.
>>This Excel beginner could use your help.
>>
>>I would like to have cell g3 display the last number added to range
>>B2:B76.
>>
>>Any help is appreciated.
>>TIA
>>MamaB
>
>