Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
BKJ --
Click on the cell you want to change, and then press CTRL-H. Enter the string of characters you want to replace (11) and then the string you want to replace it with (15). Should do the trick, and works on a range of cells as well as just one. HTH "bkj8890" wrote: =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 | |
|
|
![]() |
||||
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) |