Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
bkj8890
 
Posts: n/a
Default Min Max

=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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"