| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Min Max Editing
=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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Preventing formulas being pasted over while editing | New Users to Excel | |||
| How do I lock some fields but allow editing for others in excel | Excel Discussion (Misc queries) | |||
| Screen does not clear when exit Excel after editing. | Excel Discussion (Misc queries) | |||
| editing multiple sheets at once | Excel Discussion (Misc queries) | |||
| File is locked for Editing by user problem | Excel Discussion (Misc queries) | |||
Threaded Mode
