Find last number  
Author Message
plpalmer80





PostPosted: Thu Aug 03 10:01:06 CDT 2006 Top

Excel >> Find last number

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

Excel330  
 
 
Paul





PostPosted: Thu Aug 03 10:01:06 CDT 2006 Top

Excel >> Find last number 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



> 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





PostPosted: Thu Aug 03 10:06:44 CDT 2006 Top

Excel >> Find last number In G3 enter =LOOKUP(9.99999999999999E+307,B2:B76)


Gord Dibben MS Excel MVP




>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





PostPosted: Thu Aug 03 10:20:40 CDT 2006 Top

Excel >> Find last number Try this:

=LOOKUP(99^99,B2:B76)

--

HTH,

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



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





PostPosted: Thu Aug 03 13:03:05 CDT 2006 Top

Excel >> Find last number 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



> In G3 enter =LOOKUP(9.99999999999999E+307,B2:B76)
>
>
> Gord Dibben MS Excel MVP
>
>

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