Spreadsheet: 598705d1542663664-formula-comes-back-with-zeros-if-blank-i-dont-want-zeros-excel-forum
Sheet: Rosters

Results to be copied and valued pasted
 | P1 |  |  |  |  | P2 |  |  |  | P3 |  |  |  | P4 |  |  |  | P5 |  |  |  | P6 |  |  |  | P7
1 |  |  |  |  | 1 |  |  |  | 1 |  |  |  | 1 |  |  |  | 1 |  |  |  | 1 |  |  |  | 1
2 |  |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2
3 |  |  |  |  | 3 |  |  |  | 3 |  |  |  | 3 |  |  |  | 3 |  |  |  | 3 |  |  |  | 3
4 |  |  |  |  | 4 |  |  |  | 4 |  |  |  | 4 |  |  |  | 4 |  |  |  | 4 |  |  |  | 4
5 |  |  |  |  | 5 |  |  |  | 5 |  |  |  | 5 |  |  |  | 5 |  |  |  | 5 |  |  |  | 5
6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  | 6 |  |  |  | 6 |  |  |  | 6 |  |  |  | 6
7 |  |  |  |  | 7 |  |  |  | 7 |  |  |  | 7 |  |  |  | 7 |  |  |  | 7 |  |  |  | 7
8 |  |  |  |  | 8 |  |  |  | 8 |  |  |  | 8 |  |  |  | 8 |  |  |  | 8 |  |  |  | 8
9 |  |  |  |  | 9 |  |  |  | 9 |  |  |  | 9 |  |  |  | 9 |  |  |  | 9 |  |  |  | 9
10 |  |  |  |  | 10 |  |  |  | 10 |  |  |  | 10 |  |  |  | 10 |  |  |  | 10 |  |  |  | 10
11 |  |  |  |  | 11 |  |  |  | 11 |  |  |  | 11 |  |  |  | 11 |  |  |  | 11 |  |  |  | 11
12 |  |  |  |  | 12 |  |  |  | 12 |  |  |  | 12 |  |  |  | 12 |  |  |  | 12 |  |  |  | 12
13 |  |  |  |  | 13 |  |  |  | 13 |  |  |  | 13 |  |  |  | 13 |  |  |  | 13 |  |  |  | 13
14 |  |  |  |  | 14 |  |  |  | 14 |  |  |  | 14 |  |  |  | 14 |  |  |  | 14 |  |  |  | 14
15 |  |  |  |  | 15 |  |  |  | 15 |  |  |  | 15 |  |  |  | 15 |  |  |  | 15 |  |  |  | 15
16 |  |  |  |  | 16 |  |  |  | 16 |  |  |  | 16 |  |  |  | 16 |  |  |  | 16 |  |  |  | 16
17 |  |  |  |  | 17 |  |  |  | 17 |  |  |  | 17 |  |  |  | 17 |  |  |  | 17 |  |  |  | 17
18 |  |  |  |  | 18 |  |  |  | 18 |  |  |  | 18 |  |  |  | 18 |  |  |  | 18 |  |  |  | 18
19 |  |  |  |  | 19 |  |  |  | 19 |  |  |  | 19 |  |  |  | 19 |  |  |  | 19 |  |  |  | 19
20 |  |  |  |  | 20 |  |  |  | 20 |  |  |  | 20 |  |  |  | 20 |  |  |  | 20 |  |  |  | 20
21 |  |  |  |  | 21 |  |  |  | 21 |  |  |  | 21 |  |  |  | 21 |  |  |  | 21 |  |  |  | 21
22 |  |  |  |  | 22 |  |  |  | 22 |  |  |  | 22 |  |  |  | 22 |  |  |  | 22 |  |  |  | 22
23 |  |  |  |  | 23 |  |  |  | 23 |  |  |  | 23 |  |  |  | 23 |  |  |  | 23 |  |  |  | 23
24 |  |  |  |  | 24 |  |  |  | 24 |  |  |  | 24 |  |  |  | 24 |  |  |  | 24 |  |  |  | 24
25 |  |  |  |  | 25 |  |  |  | 25 |  |  |  | 25 |  |  |  | 25 |  |  |  | 25 |  |  |  | 25
26 |  |  |  |  | 26 |  |  |  | 26 |  |  |  | 26 |  |  |  | 26 |  |  |  | 26 |  |  |  | 26
27 |  |  |  |  | 27 |  |  |  | 27 |  |  |  | 27 |  |  |  | 27 |  |  |  | 27 |  |  |  | 27
28 |  |  |  |  | 28 |  |  |  | 28 |  |  |  | 28 |  |  |  | 28 |  |  |  | 28 |  |  |  | 28
29 |  |  |  |  | 29 |  |  |  | 29 |  |  |  | 29 |  |  |  | 29 |  |  |  | 29 |  |  |  | 29
30 |  |  |  |  | 30 |  |  |  | 30 |  |  |  | 30 |  |  |  | 30 |  |  |  | 30 |  |  |  | 30
31 |  |  |  |  | 31 |  |  |  | 31 |  |  |  | 31 |  |  |  | 31 |  |  |  | 31 |  |  |  | 31
32 |  |  |  |  | 32 |  |  |  | 32 |  |  |  | 32 |  |  |  | 32 |  |  |  | 32 |  |  |  | 32
33 |  |  |  |  | 33 |  |  |  | 33 |  |  |  | 33 |  |  |  | 33 |  |  |  | 33 |  |  |  | 33
34 |  |  |  |  | 34 |  |  |  | 34 |  |  |  | 34 |  |  |  | 34 |  |  |  | 34 |  |  |  | 34
35 |  |  |  |  | 35 |  |  |  | 35 |  |  |  | 35 |  |  |  | 35 |  |  |  | 35 |  |  |  | 35
36 |  |  |  |  | 36 |  |  |  | 36 |  |  |  | 36 |  |  |  | 36 |  |  |  | 36 |  |  |  | 36
37 |  |  |  |  | 37 |  |  |  | 37 |  |  |  | 37 |  |  |  | 37 |  |  |  | 37 |  |  |  | 37
38 |  |  |  |  | 38 |  |  |  | 38 |  |  |  | 38 |  |  |  | 38 |  |  |  | 38 |  |  |  | 38
39 |  |  |  |  | 39 |  |  |  | 39 |  |  |  | 39 |  |  |  | 39 |  |  |  | 39 |  |  |  | 39
40 |  |  |  |  | 40 |  |  |  | 40 |  |  |  | 40 |  |  |  | 40 |  |  |  | 40 |  |  |  | 40
 |  |  |  |  |  |  | Results to be copied and value pasted
 | P1 |  | Ignore D column | Nick? | FLA | Source formula | Source formula |  |  | Results for Roll Sheet and GMWin |  |  |  |  |  | Source formula |  | Source Formula
1
2 |  |  |  |  |  |  |  |  | 1
3 |  |  |  |  |  |  |  |  | 2
4 |  |  |  |  |  |  |  |  | 3
5 |  |  |  |  |  |  |  |  | 4
6 |  |  |  |  |  |  |  |  | 5
7 |  |  |  |  |  |  |  |  | 6
8 |  |  |  |  |  |  |  |  | 7
9 |  |  |  |  |  |  |  |  | 8
10 |  |  |  |  |  |  |  |  | 9
11 |  |  |  |  |  |  |  |  | 10
12 |  |  |  |  |  |  |  |  | 11
13 |  |  |  |  |  |  |  |  | 12
14 |  |  |  |  |  |  |  |  | 13
15 |  |  |  |  |  |  |  |  | 14
16 |  |  |  |  |  |  |  |  | 15
17 |  |  |  |  |  |  |  |  | 16
18 |  |  |  |  |  |  |  |  | 17
19 |  |  |  |  |  |  |  |  | 18
20 |  |  |  |  |  |  |  |  | 19
21 |  |  |  |  |  |  |  |  | 20
22 |  |  |  |  |  |  |  |  | 21
23 |  |  |  |  |  |  |  |  | 22
24 |  |  |  |  |  |  |  |  | 23
25 |  |  |  |  |  |  |  |  | 24
26 |  |  |  |  |  |  |  |  | 25
27 |  |  |  |  |  |  |  |  | 26
28 |  |  |  |  |  |  |  |  | 27
29 |  |  |  |  |  |  |  |  | 28
30 |  |  |  |  |  |  |  |  | 29
31 |  |  |  |  |  |  |  |  | 30
32 |  |  |  |  |  |  |  |  | 31
33 |  |  |  |  |  |  |  |  | 32
34 |  |  |  |  |  |  |  |  | 33
35 |  |  |  |  |  |  |  |  | 34
36 |  |  |  |  |  |  |  |  | 35
37 |  |  |  |  |  |  |  |  | 36
38 |  |  |  |  |  |  |  |  | 37
39 |  |  |  |  |  |  |  |  | 38
40 |  |  |  |  |  |  |  |  | 39
41 |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  | 41
 |  |  | Ignore D column | Nick? | FLA | Source formula | Source formula |  |  | Results for Roll Sheet and GMWin |  |  |  |  |  | Source formula |  | Source Formula
 | P2
1 |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  | 20
21 |  |  |  |  |  |  |  |  | 21
22 |  |  |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  |  |  | 24
25 |  |  |  |  |  |  |  |  | 25
26 |  |  |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  |  |  | 27
28 |  |  |  |  |  |  |  |  | 28
29 |  |  |  |  |  |  |  |  | 29
30 |  |  |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  |  |  | 31
32 |  |  |  |  |  |  |  |  | 32
33 |  |  |  |  |  |  |  |  | 33
34 |  |  |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  |  |  | 35
36 |  |  |  |  |  |  |  |  | 36
37 |  |  |  |  |  |  |  |  | 37
38 |  |  |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  |  |  | 39
40 |  |  |  |  |  |  |  |  | 40
41 |  |  |  |  |  |  |  |  | 41
 |  |  | Ignore D column | Nick? | FLA | Source formula | Source formula |  |  | Results for Roll Sheet and GMWin |  |  |  |  |  | Source formula |  | Source Formula
 | P3
1 |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  | 20
21 |  |  |  |  |  |  |  |  | 21
22 |  |  |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  |  |  | 24
25 |  |  |  |  |  |  |  |  | 25
26 |  |  |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  |  |  | 27
28 |  |  |  |  |  |  |  |  | 28
29 |  |  |  |  |  |  |  |  | 29
30 |  |  |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  |  |  | 31
32 |  |  |  |  |  |  |  |  | 32
33 |  |  |  |  |  |  |  |  | 33
34 |  |  |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  |  |  | 35
36 |  |  |  |  |  |  |  |  | 36
37 |  |  |  |  |  |  |  |  | 37
38 |  |  |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  |  |  | 39
40 |  |  |  |  |  |  |  |  | 40
41 |  |  |  |  |  |  |  |  | 41
 |  |  | Ignore D column | Nick? | FLA | Source formula | Source formula |  |  | Results for Roll Sheet and GMWin |  |  |  |  |  | Source formula |  | Source Formula
 | P4
1 |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  | 20
21 |  |  |  |  |  |  |  |  | 21
22 |  |  |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  |  |  | 24
25 |  |  |  |  |  |  |  |  | 25
26 |  |  |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  |  |  | 27
28 |  |  |  |  |  |  |  |  | 28
29 |  |  |  |  |  |  |  |  | 29
30 |  |  |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  |  |  | 31
32 |  |  |  |  |  |  |  |  | 32
33 |  |  |  |  |  |  |  |  | 33
34 |  |  |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  |  |  | 35
36 |  |  |  |  |  |  |  |  | 36
37 |  |  |  |  |  |  |  |  | 37
38 |  |  |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  |  |  | 39
40 |  |  |  |  |  |  |  |  | 40
41 |  |  |  |  |  |  |  |  | 41
 |  |  | Ignore D column | Nick? | FLA | Source formula | Source formula |  |  | Results for Roll Sheet and GMWin |  |  |  |  |  | Source formula |  | Source Formula
 | P5
1 |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  | 20
21 |  |  |  |  |  |  |  |  | 21
22 |  |  |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  |  |  | 24
25 |  |  |  |  |  |  |  |  | 25
26 |  |  |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  |  |  | 27
28 |  |  |  |  |  |  |  |  | 28
29 |  |  |  |  |  |  |  |  | 29
30 |  |  |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  |  |  | 31
32 |  |  |  |  |  |  |  |  | 32
33 |  |  |  |  |  |  |  |  | 33
34 |  |  |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  |  |  | 35
36 |  |  |  |  |  |  |  |  | 36
37 |  |  |  |  |  |  |  |  | 37
38 |  |  |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  |  |  | 39
40 |  |  |  |  |  |  |  |  | 40
41 |  |  |  |  |  |  |  |  | 41
 |  |  | Ignore D column | Nick? | FLA | Source formula | Source formula |  |  | Results for Roll Sheet and GMWin |  |  |  |  |  | Source formula |  | Source Formula
 | P6
1 |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  | 20
21 |  |  |  |  |  |  |  |  | 21
22 |  |  |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  |  |  | 24
25 |  |  |  |  |  |  |  |  | 25
26 |  |  |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  |  |  | 27
28 |  |  |  |  |  |  |  |  | 28
29 |  |  |  |  |  |  |  |  | 29
30 |  |  |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  |  |  | 31
32 |  |  |  |  |  |  |  |  | 32
33 |  |  |  |  |  |  |  |  | 33
34 |  |  |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  |  |  | 35
36 |  |  |  |  |  |  |  |  | 36
37 |  |  |  |  |  |  |  |  | 37
38 |  |  |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  |  |  | 39
40 |  |  |  |  |  |  |  |  | 40
41 |  |  |  |  |  |  |  |  | 41
 |  |  | Ignore D column | Nick? | FLA | Source formula | Source formula |  |  | Results for Roll Sheet and GMWin |  |  |  |  |  | Source formula |  | Source Formula
 | P7
1 |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  | 20
21 |  |  |  |  |  |  |  |  | 21
22 |  |  |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  |  |  | 24
25 |  |  |  |  |  |  |  |  | 25
26 |  |  |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  |  |  | 27
28 |  |  |  |  |  |  |  |  | 28
29 |  |  |  |  |  |  |  |  | 29
30 |  |  |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  |  |  | 31
32 |  |  |  |  |  |  |  |  | 32
33 |  |  |  |  |  |  |  |  | 33
34 |  |  |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  |  |  | 35
36 |  |  |  |  |  |  |  |  | 36
37 |  |  |  |  |  |  |  |  | 37
38 |  |  |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  |  |  | 39
40 |  |  |  |  |  |  |  |  | 40
41 |  |  |  |  |  |  |  |  | 41