Sorry for the "late" solution !

For the range A10:H10 this array formula:

{=MIN(IF(A10:G10 <= B10:H10, COLUMN(A10:G10) - COLUMN(A10),
COLUMNS(A10:G10)))}

should give the right result, and it is not limited in size...

--
Festina Lente


"SteveC" wrote:

Col A through D contain the data. Col E contains the formula I'm asking
about:
Col A Col B Col C Col D Col E
7 6 7 2 1
4 3 2 1 4
8 10 9 8 -
5 3 2 10 3

I'd like to Col E to count consecutive improvements for each row of data
starting in Col A relative to Col B, then Col B relative to Col C.

Is there a way to do this?

Thanks a lot!