Counting a streak

Giganews Newsgroups
Subject: Counting a streak
Posted by:  @Homeonthecouch (…@home.com)
Date: Wed, 31 Jan 2007

Is it possible to count and report the greater streak in a set of streaks?
e.g.
A1 1
A2 1
A3 1
A4 1
A5 1
A6 0
A7 1
A8 1
A9 0

The cell would report the streak as being 5 as it is greater than the A7:A8
streak of 2

As always any help is appreciated

Andrew.

Replies