changing value

[superkopite]

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

Regards

James

 

[Trevor Shuttleworth]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[superkopite]

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

 

[superkopite]

thanks alot this works a treat

It so easy when you know how!!!

 

[Trevor Shuttleworth]

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

Regards

"superkopite" <[email protected]>
wrote in message
news:[email protected]...