Results 1 to 4 of 4

winning/losing streak without dates in order

Threaded View

  1. #1
    Registered User
    Join Date
    02-16-2008
    Posts
    48

    winning/losing streak without dates in order

    I have a tough one here:

    I need to calculated a longest ever winning streak and current winning streak for a largest set of data.

    The data is set up as follows:

    Column A [B C D] [E F G] [H I J]
    List of teams each brack represents a team
    (can't be sorted) B / E / H all would be dates
    C / F / I all would be W/L
    D / G / J all would be scores

    I need to determine the longest ever winning streak and current winning streak for each [bracketed] team. The problem is column A is fixed and can't be sorted, therefore the dates are out of order.

    Please let me know if this is impossible.

    Thanx
    Chemmiah
    Attached Files Attached Files
    Last edited by chemmiah; 01-28-2011 at 01:49 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1