I don't have time to test right now but replacing "<" with "<" should work.

--

Vasant


"yeedao" wrote in
message ...

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.


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