# Min Max Editing

1. ## 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

2. ## RE: Min Max Editing

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
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1