- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- Using Countif to Count Consecutive Relative Increases in Numbers

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!

- RE: Using Countif to Count Consecutive Relative Increases in Numbers posted by JLatham on Tue, 2 May 2006
- RE: Using Countif to Count Consecutive Relative Increases in Numbers posted by PapaDos on Wed, 27 Sep 2006