Using Countif to Count Consecutive Relative Increases in Numbers

Giganews Newsgroups
Subject: Using Countif to Count Consecutive Relative Increases in Numbers
Posted by:  SteveC
Date: Tue, 2 May 2006

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!

Replies