| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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  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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
changing value
i always did get my m and n the wrong way round  -- superkopite ------------------------------------------------------------------------ superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496 View this thread: http://www.excelforum.com/showthread...hreadid=492006 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
| how do i replace ( with / without changing format to fraction | Excel Worksheet Functions | |||
| Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
| How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
| changing page break in an excel file | New Users to Excel | |||
Linear Mode
