miles00577
New Member
- Joined
- Aug 21, 2008
- Messages
- 18
I've got a yearly history of game results and have just started incorporating winning/losing streaks. I've got a top 10 list of longest streaks, but I want to incorporate the dates of each streak. For example, on the data below, I want to be able to pull the date data from the first and last row of each streak.
COLUMNS
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>Basically, the desired end result I'm seeking is this:
<tbody>
</tbody>
I've already got the right column to find LARGE in the AU Column from the spreadsheet, but not quite sure how get the desired end result for the date data.
COLUMNS
<tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
9-4-2002 - 9-14-2002 | 4 |
8-26-2002 - 8-28-2002 | 2 |
<tbody>
</tbody>
I've already got the right column to find LARGE in the AU Column from the spreadsheet, but not quite sure how get the desired end result for the date data.