On Tue, 23 Mar 2010 18:00:18 +0000, Roger Govier
wrote:

No need for a macro.
In Z2 enter
=IF(OR(B2="A",B2="B"),MIN(MIN(C2:K2),MIN(M2:U2)), "")

Copy down the sheet, as far as you wish.
As rows become populated, then the formula will produce the result.

I'm trying to produce a new row, not a new column.

For instance:

New Row name 12 12 13 5 8 ...
A 12 55 33 18 9 ...
B 33 12 88 5 22 ...
C 3 8 12 55 0 ...
B 33 88 13 5 8 ...
....




--
"In no part of the constitution is more wisdom to be found,
than in the clause which confides the question of war or peace
to the legislature, and not to the executive department."

- James Madison