=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

Why not just copy it to 4 rows lower, then cut and paste it up 3 rows?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"bkj8890" wrote in message
...

=MIN(F11,K11,P11,U11,Z11,AE11,AJ11,AO11,AT11,AY11, BD11,BI11,BN11,BS11,BX11,C
C11,CH11,CM11)


=MIN(F15,K15,P15,U15,Z15,AE15,AJ15,AO15,AT15,AY15, BD15,BI15,BN15,BS15,BX15,C
C15,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

If you always check every 5th column

=MIN(IF((MOD(COLUMN(F11:CM11),5)=1)*(F11:CM11<"") ,MOD(COLUMN(F11:CM11),5)=1)*(F11:CM11))

entered with ctrl + shift & enter

if there cannot be any blank cells it can be shorten to

=MIN((MOD(COLUMN(F11:CM11),5)=1)*(F1:CM11))


--

Regards,

Peo Sjoblom




"bkj8890" wrote in message
...
=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

If you use that formula it is much easier to change to different rows


--

Regards,

Peo Sjoblom


"Peo Sjoblom" wrote in message
...
If you always check every 5th column

=MIN(IF((MOD(COLUMN(F11:CM11),5)=1)*(F11:CM11<"") ,MOD(COLUMN(F11:CM11),5)=1)*(F11:CM11))

entered with ctrl + shift & enter

if there cannot be any blank cells it can be shorten to

=MIN((MOD(COLUMN(F11:CM11),5)=1)*(F1:CM11))


--

Regards,

Peo Sjoblom




"bkj8890" wrote in message
...
=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