Data Range
|
A |
B |
C |
D |
E |
F |
1 |
|
|
|
|
|
|
2 |
12 |
-13 |
-1 |
____ |
Consecutive Win |
2 |
3 |
2 |
-6 |
-4 |
____ |
Consecutive loss |
3 |
4 |
-8 |
-6 |
-14 |
____ |
Current win/loss Streak |
2 W |
5 |
14 |
-5 |
9 |
____ |
|
|
6 |
15 |
-15 |
0 |
____ |
|
|
7 |
3 |
-4 |
-1 |
____ |
|
|
8 |
5 |
3 |
8 |
____ |
|
|
9 |
2 |
-2 |
0 |
____ |
|
|
10 |
|
|
|
|
|
|
11 |
|
|
|
|
|
|
All formulas are array formulas**.
=LOOKUP(E1+100,IF(LOOKUP(1E+100,C2:C11)>=0,FREQUENCY(IF(ISNUMBER(C$2:C$11),IF(C$2:C$11>=0,ROW(C$2:C$11))),IF(C$2:C$11<0,ROW(C$2:C$11))),FREQUENCY(IF(ISNUMBER(C$2:C$11),IF(C$2:C$11<0,ROW(C$2:C$11))),IF(C$2:C$11>0,ROW(C$2:C$11)))))&" "&IF(LOOKUP(1E+100,C2:C11)<0,"L","W")
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Bookmarks