What I am trying to do is find the AVERAGE length it took to get a victory per opponent.
Fox example
NYY Vs TOR
played 4-1-08 through 4-3-08
it took the Yankees 1 game to gain a victory
NYY Vs TB
played 4-5-08 through 4-7-08
it took the Yankees 2 games to gain a victory
so the average for the first two series was 1.5
Anybody got a formula to do this?
Matt
NEW YORK YANKEES VS ...
COLUMN A, B, C, D
04/01/2008 TOR W 3-2
04/02/2008 TOR L 2-5
04/03/2008 TOR W 3-2
04/05/2008 TB L 3-6
04/06/2008 TB W 2-0
04/07/2008 TB W 6-1
04/08/2008 @ KC L 2-5
04/09/2008 @ KC L 0-4
04/10/2008 @ KC W 6-1
04/11/2008 @ BOS W 4-1
04/12/2008 @ BOS L 3-4
04/13/2008 @ BOS L 5-8
Fox example
NYY Vs TOR
played 4-1-08 through 4-3-08
it took the Yankees 1 game to gain a victory
NYY Vs TB
played 4-5-08 through 4-7-08
it took the Yankees 2 games to gain a victory
so the average for the first two series was 1.5
Anybody got a formula to do this?
Matt
NEW YORK YANKEES VS ...
COLUMN A, B, C, D
04/01/2008 TOR W 3-2
04/02/2008 TOR L 2-5
04/03/2008 TOR W 3-2
04/05/2008 TB L 3-6
04/06/2008 TB W 2-0
04/07/2008 TB W 6-1
04/08/2008 @ KC L 2-5
04/09/2008 @ KC L 0-4
04/10/2008 @ KC W 6-1
04/11/2008 @ BOS W 4-1
04/12/2008 @ BOS L 3-4
04/13/2008 @ BOS L 5-8