Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=MIN(F11,K11,P11,U11,Z11,AE11,AJ11,AO11,AT11,AY11, BD11,BI11,BN11,BS11,BX11,CC11,CH11,CM11)
=MIN(F15,K15,P15,U15,Z15,AE15,AJ15,AO15,AT15,AY15, BD15,BI15,BN15,BS15,BX15,CC15,CH15,CM15) I would like to know if there is a way to change the numbers withour changing each one individually?The first line is a MIN that I selected by holding the Ctrl and picking each box. The second line, I picked the cell and pasted then changed the numbers only one at a time. If I know where the next line comes in at, can I just change the all the numbers at one time but keep the same formula? Thanks |