Good morning. Its Friday the 13th
I have data in JE and JF. JG shows the number of 2's in JE and JH shows whats to the right. In the actual spreadsheet JG and JH are several columns over. Also some data might repeat. im trying to use lookup but im having trouble with keeping it grouped together like the sample below. any ideas?
I have data in JE and JF. JG shows the number of 2's in JE and JH shows whats to the right. In the actual spreadsheet JG and JH are several columns over. Also some data might repeat. im trying to use lookup but im having trouble with keeping it grouped together like the sample below. any ideas?
Excel 2012 | ||||||
---|---|---|---|---|---|---|
JE | JF | JG | JH | |||
6 | Press | Total mld change time | look up press 2 | time | ||
7 | 27 | 0:35 | 2 | 0:40 | ||
8 | 2 | 0:40 | 2 | 0:48 | ||
9 | 19 | 2:44 | 2 | 0:25 | ||
10 | 12 | 0:40 | ||||
11 | 25 | 0:55 | ||||
12 | 10 | 0:30 | ||||
13 | 31 | 0:23 | ||||
14 | 27 | 0:28 | ||||
15 | 9 | 0:38 | ||||
16 | 29 | 0:34 | ||||
17 | 15 | 1:05 | ||||
18 | 28 | 0:20 | ||||
19 | 11 | 0:35 | ||||
20 | 17 | 0:42 | ||||
21 | 2 | 0:48 | ||||
22 | 12 | 0:51 | ||||
23 | 15 | 5:31 | ||||
24 | 18 | 0:35 | ||||
25 | 13 | 1:03 | ||||
26 | 8 | 28:10 | ||||
27 | 31 | 0:15 | ||||
28 | 17 | 0:35 | ||||
29 | 9 | 0:30 | ||||
30 | 9 | 0:54 | ||||
31 | 11 | 0:32 | ||||
32 | 27 | 0:40 | ||||
33 | 20 | 0:38 | ||||
34 | 28 | 0:25 | ||||
35 | 26 | 0:30 | ||||
36 | 15 | 1:34 | ||||
37 | 31 | 0:20 | ||||
38 | 28 | 0:20 | ||||
39 | 15 | 4:00 | ||||
40 | 20 | 0:26 | ||||
41 | 17 | 0:30 | ||||
42 | 13 | 1:05 | ||||
43 | 5 | 0:45 | ||||
44 | 30 | 0:58 | ||||
45 | 13 | 0:47 | ||||
46 | 6 | 0:58 | ||||
47 | 11 | 0:37 | ||||
48 | 27 | 0:33 | ||||
49 | 25 | 0:30 | ||||
50 | 2 | 0:25 | ||||
51 | 10 | 0:15 | ||||
52 | 19 | 1:42 | ||||
53 | 8 | 0:00 | ||||
54 | 31 | 0:44 | ||||
55 | 21 | 0:29 | ||||
56 | 27 | 0:25 | ||||
57 | 29 | 0:33 | ||||
58 | 18 | 0:42 | ||||
59 | 22 | 0:33 | ||||
60 | 23 | 0:45 | ||||
61 | 15 | 1:21 | ||||
62 | 13 | 0:20 | ||||
63 | 17 | 0:29 | ||||
64 | 28 | 0:19 | ||||
65 | 31 | 0:19 | ||||
66 | 20 | 0:27 | ||||
67 | 17 | 0:43 | ||||
68 | 21 | 0:15 | ||||
69 | 0 | 0:00 | ||||
70 | 0 | 0:00 | ||||
71 | 0 | 0:00 | ||||
72 | 0 | 0:00 | ||||
73 | 0 | 0:00 | ||||
74 | 0 | 0:00 | ||||
75 | 0 | 0:00 | ||||
76 | 0 | 0:00 | ||||
77 | 0 | 0:00 | ||||
78 | 0 | 0:00 | ||||
79 | 0 | 0:00 | ||||
80 | 0 | 0:00 | ||||
81 | 0 | 0:00 | ||||
82 | 0 | 0:00 | ||||
83 | 0 | 0:00 | ||||
84 | 0 | 0:00 | ||||
85 | 0 | 0:00 | ||||
86 | 0 | 0:00 | ||||
87 | 0 | 0:00 | ||||
88 | 0 | 0:00 | ||||
89 | 0 | 0:00 | ||||
90 | 0 | 0:00 | ||||
91 | 0 | 0:00 | ||||
92 | 0 | 0:00 | ||||
93 | 0 | 0:00 | ||||
94 | 0 | 0:00 | ||||
95 | 0 | 0:00 | ||||
96 | 0 | 0:00 | ||||
97 | 0 | 0:00 | ||||
98 | 0 | 0:00 | ||||
99 | 0 | 0:00 | ||||
100 | 0 | 0:00 | ||||
101 | 0 | 0:00 | ||||
All S.M.E.D. Data |