changing value
 

Hiya guys and gals

i need to make my cell m20, the same value as the last figure entered
in cells a20:n20.

eg. if a20 =200, B20=400, C20=800 and the rest are blank then N20
should be 800

hope i have explained this okay:eek:

Regards

James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=492006

changing value
 

James

one way:

=OFFSET($A20,,COUNTA($A20:$M20)-1)

You seem to have confused m20 and n20 along the way. The above answer
assumes that n20 follows m20 and that's what you meant.

Regards

Trevor


"superkopite"
wrote in message
...

Hiya guys and gals

i need to make my cell m20, the same value as the last figure entered
in cells a20:n20.

eg. if a20 =200, B20=400, C20=800 and the rest are blank then N20
should be 800

hope i have explained this okay:eek:

Regards

James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile:
http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=492006

changing value
 

i always did get my m and n the wrong way round:confused:


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=492006

changing value
 

thanks alot this works a treat

It so easy when you know how!!!


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=492006

changing value
 

You're welcome. Thanks for letting me know it does what you want.

Regards

"superkopite"
wrote in message
...

thanks alot this works a treat

It so easy when you know how!!!


--
superkopite
------------------------------------------------------------------------
superkopite's Profile:
http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=492006