Find last number

M

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
 
P

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
 
R

RagDyeR

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
 
M

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
 
Top