ABCDEFGHIJKLMNOPQRSTUVW
1
DataFormula Break DownWhole formula
2
HELPReturns Relative positioncan return an offset cell, given a referene, you can specify a cell x, y, h, w away from that sell This is a text search, it can be done numerous ways, this seems to be the less error prone approach
3
7OFFSETthe word in D3 contains OFF
4
see how "test" is 7 cells from the topsee how "OFFSET", is 5 to the right of, and 3 bellow a1
5
How do we applythis counts where test is from the "top"this uses Match in offset to get a different cell, relative to test..kind ofsearch for test, if so print "Number Pass:"Lets combine match and offset and the if into something that counts how many passes there aresearch for Test, if so print FailLets combine match and offset and the if into something that counts how many fails there aresearch for Test, if so print Total testlets count all the tests from one "Test" to the nextsearch for test, print result of percentage formula
6
DATAMATCHOFFSETIF == TESTCOMBINEIF == TESTCOMBINEIF == TESTCOMBINEBasic Math FormulaAll TogetherOne extra
7
Test14HELPNumber Pass:6Number Fail:6Total Tests:1250.00%50.00%Test Pass: 50%
8
pass13
9
pass12
10
pass11How do we apply
11
pass10DATA
12
pass9
13
pass8pass
14
fail7pass
15
fail6pass
16
fail5pass
17
fail4pass
18
fail3pass
19
fail2fail
20
1fail
21
Test11failNumber Pass:6Number Fail:3Total Tests:966.67%66.67%Test Pass: 67%
22
pass10fail
23
fail9fail
24
pass8fail
25
pass7
26
fail6
27
pass5pass
28
fail4fail
29
pass3pass
30
pass2pass
31
1fail
32
Test9passNumber Pass:4Number Fail:3Total Tests:757.14%57.14%Test Pass: 57%
33
pass8fail
34
pass7pass
35
fail6pass
36
fail5
37
pass4
38
fail3pass
39
pass2pass
40
41
Test<-- try deleting thatTotal Tests:10.00%Test Pass: 0%
42
^^ Notice how we have to finish with test
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100