Originally Posted by

**mrvp**
Hi,

Thanks for having another go. I haven't figured out all of your formulas yet but some things are definitely off:

=COUNTIF($I$2:$I$776,N2) - has to provide total number of wins as I originally thought (e.g. count the number of times Air Force in this case appears in the winning team column and would apply to either mine or your workbooks)

I haven't figured out:

=SUMPRODUCT((B$2:B$1000=O2)*(C$2:C$1000>E$2:E$1000)+(F$2:F$1000=O2)*(D$2:D$1000>E$2:E$1000))

completely yet - but if you select them in Y3 (or just run a filter on the winning column - I on either sheet) you will see that they appear 7 times as per the result of my formula against the 4 from your formula. My N is your O because of the rank column added in.

The ranking workup in cells S to W is super efficient though (currently I just copy things onto a different worksheet and sort them by rank which I could put a Macro together to do I guess) and the Y2 and Y3 Pick Team and then highlight their results in I and L is clever (how did you do that? - I've looked and couldn't figure it out). It would be the easiest way of tracking a streak manually but I was still looking to automate the process though (via a formula if possible).

## Bookmarks