|
|
|
Author |
Message |
plpalmer80
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
Posted: 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
>
>
|
|
|
|
|
|
|