Assuming that Columns A through T contain your data...

If there will always be at least one number less than 1, try...

=MATCH(TRUE,SUBTOTAL(9,OFFSET(A1,0,COLUMN(A1:T1)-COLUMN(A1)))<1,0)-1

...confirmed with CONTROL+SHIFT+ENTER, otherwise try...

=IF(COUNTIF(A1:T1,"=1")<COLUMNS(A1:T1),MATCH(TRU E,SUBTOTAL(9,OFFSET(A1,0,COLUMN(A1:T1)-COLUMN(A1)))<1,0)-1,COLUMNS(A1:T1))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

yeedao Wrote:
Thanks for the help and sorry for not making the problem statement
clearer.

Any number continuously from the left equal to 1 or greater than 1 is a
saturation point; The goal is to count how many points are saturated;

If a number to its left is less than 1 and the number itself is greater
than 1, this number is not counted as saturation but as noise.

Example:
1.001, 1.011, 0.98, 0.99,0.8, ..., Count =2; total 20 numbers;
0.99, 08,1.002, 1.003, 0.87, ...., Count =0; total 20 numbers;
1.012, 0.98,0.78,1.02,0.809,...., Count = 1; total 20 numbers;

Each number is in a cell; Each row has 20 numbers;

I thought I can use 1 as an example but it does cause confusion to
others and to myself. It is not a integer, it can be 1.001, 1.011,
1.0002, ....;

I am not sure if that equation still works.

Thanks again.


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=395619