Thanks Latham, there's no urgency. I''m not that good with macros, so I dont'
want you to waste your time. Then again, if this is a challenge that
interests you, I would enjoy seeing it if only to learn something. Thanks
again!

"JLatham" wrote:

SteveC, Let me look at your questions this evening so I can hopefully come up
with a one-answer-answers-all answer. We're going to be limited in the
current method by the nested function limit in Excel - 7 nested functions.

The basic premise of the current formula was that if the value to the right
of a cell was greater than the current cell (i.e. A1 B1) then set the
result to 1, otherwise set it to zero. The complication comes in when you
realize that any time the constant decrease in values from left to right is
interrupted that you don't/can't count any further at all even if you have an
apparent valid sequence later on: the 10 7 10 9 situation: the second 10
nullifies any further 'valid' sequences.

If you don't mind working with VBA macros, I think it would be easier to
code up a generic solution to this problem than to try to extend the logic
through nested IF statements.

Besides, nested IF's give me a headache <g

"SteveC" wrote:

For this data in row 20, ColM - ColT
17.7% 16.5% 15.2% 14.8% 14.3% 12.5% #DIV/0! #DIV/0! #DIV/0!

this formula:
=IF(M20N20,1,0)+IF(O20<N20,IF(M20N20,1,0),0)+IF( N20O20,IF(M20N20,1,0),0)+IF(O20P20,IF(N20O20,I F(M20N20,1,0),0),0)+IF(P20Q20,IF(O20P20,IF(N20 O20,IF(M20N20,1,0),0),0),0)+IF(Q20R20,IF(P20Q20 ,IF(O20P20,IF(N20O20,IF(M20N20,1,0),0),0),0),0) +IF(R20S20,IF(Q20R20,IF(P20Q20,IF(O20P20,IF(N2 0O20,IF(M20N20,1,0),0),0),0),0),0)+IF(S20T20,IF (R20S20,IF(Q20R20,IF(P20Q20,IF(O20P20,IF(N20O 20,IF(M20N20,1,0),0),0),0),0),0),0)

returns an error

Is there away to still count the consecutive improvements in the first few
columns?

The prior post where I suggested returning a 0 if an error is discovered
wouldn't work...