Spreadsheet: 167825d1342111237-consolidate-and-reference-range-sample-worksheet
Sheet: SheetB

Item number | Date
1 | 2011-09-08 00:00:00 |  | Note: Table currently contains 347 items. This number will increase, and dates will be added to both new and existing items
2 | 2011-02-14 00:00:00 |  | Therefore this needs to be reflected in the Data Validation range in SheetA
3
4 | 2011-02-14 00:00:00
5
6
7
8
9
10
11
12
13
14
15
16
17 | 2011-02-14 00:00:00
18
19
20
21 | 2011-02-14 00:00:00
22
23
24
25
26
27 | 2011-02-14 00:00:00
28
29
30
31 | 2011-02-14 00:00:00
32
33 | 2011-02-14 00:00:00
34
35 | 2011-02-14 00:00:00
36
37
38
39
40
41
42
43 | 2011-02-14 00:00:00
44
45
46
47
48
49
50
51
52
53
54
55
56 | 2011-02-14 00:00:00
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 | 2011-05-04 00:00:00
82
83
84
85 | 2011-03-22 00:00:00
86
87
88
89
90
91 | 2012-07-09 00:00:00
92 | 2011-05-04 00:00:00
93 | 2010-11-07 00:00:00
94
95
96
97 | 2011-09-08 00:00:00
98 | 2011-05-04 00:00:00
99 | 2011-05-04 00:00:00
100 | 2012-07-09 00:00:00
101 | 2011-05-04 00:00:00
102 | 2011-02-14 00:00:00
103
104 | 2011-03-22 00:00:00
105
106 | 2011-02-23 00:00:00
107 | 2011-09-08 00:00:00
108 | 2011-02-23 00:00:00
109 | 2012-07-09 00:00:00
110
111
112
113
114
115 | 2011-03-22 00:00:00
116
117
118 | 2011-02-23 00:00:00
119 | 2011-02-14 00:00:00
120 | 2011-02-23 00:00:00
121 | 2011-09-08 00:00:00
122
123 | 2011-05-04 00:00:00
124 | 2011-02-23 00:00:00
125
126
127
128 | 2011-02-14 00:00:00
129 | 2011-02-14 00:00:00
130
131 | 2011-02-23 00:00:00
132 | 2011-02-23 00:00:00
133 | 2011-02-23 00:00:00
134
135 | 2011-02-23 00:00:00
136 | 2011-02-23 00:00:00
137 | 2011-02-23 00:00:00
138
139 | 2011-02-14 00:00:00
140
141 | 2011-02-23 00:00:00
142
143
144
145
146 | 2011-02-23 00:00:00
147 | 2011-07-19 00:00:00
148
149
150 | 2011-09-08 00:00:00
151 | 2012-07-09 00:00:00
152
153 | 2011-03-22 00:00:00
154
155 | 2011-03-22 00:00:00
156
157
158
159
160
161
162
163 | 2011-09-08 00:00:00
164 | 2012-07-09 00:00:00
165 | 2012-07-09 00:00:00
166
167
168
169
170
171
172 | 2011-03-22 00:00:00
173
174 | 2011-09-08 00:00:00
175 | 2011-05-04 00:00:00
176
177 | 2011-09-08 00:00:00
178 | 2011-09-08 00:00:00
179 | 2011-02-14 00:00:00
180 | 2010-11-07 00:00:00
181 | 2011-09-08 00:00:00
182
183
184
185
186 | 2011-09-08 00:00:00
187
188 | 2011-05-04 00:00:00
189 | 2011-05-04 00:00:00
190 | 2011-05-04 00:00:00
191 | 2011-05-04 00:00:00
192 | 2011-05-04 00:00:00
193 | 2011-05-04 00:00:00
194 | 2011-05-04 00:00:00
195
196 | 2010-04-16 00:00:00
197 | 2012-07-09 00:00:00
198 | 2010-08-28 00:00:00
199 | 2011-03-22 00:00:00
200 | 2011-03-22 00:00:00
201 | 2011-09-08 00:00:00
202 | 2011-05-04 00:00:00
203
204
205
206 | 2012-07-09 00:00:00
207
208
209
210 | 2011-02-23 00:00:00
211 | 2011-09-08 00:00:00
212
213
214 | 2011-03-22 00:00:00
215 | 2012-07-09 00:00:00
216 | 2012-07-09 00:00:00
217 | 2012-07-09 00:00:00
218
219
220
221 | 2012-07-09 00:00:00
222
223 | 2012-07-09 00:00:00
224
225 | 2011-09-08 00:00:00
226 | 2010-11-07 00:00:00
227
228 | 2010-11-07 00:00:00
229 | 2010-12-06 00:00:00
230 | 2010-12-06 00:00:00
231 | 2010-12-06 00:00:00
232 | 2010-11-07 00:00:00
233 | 2010-12-06 00:00:00
234 | 2010-12-06 00:00:00
235 | 2010-12-06 00:00:00
236 | 2010-12-06 00:00:00
237 | 2010-12-06 00:00:00
238 | 2010-12-06 00:00:00
239 | 2010-12-06 00:00:00
240 | 2010-12-06 00:00:00
241
242
243 | 2011-03-22 00:00:00
244 | 2011-09-08 00:00:00
245 | 2011-03-22 00:00:00
246
247
248 | 2011-05-04 00:00:00
249 | 2011-05-04 00:00:00
250 | 2012-07-09 00:00:00
251 | 2010-11-07 00:00:00
252
253
254 | 2010-11-07 00:00:00
255 | 2012-07-09 00:00:00
256
257 | 2010-01-23 00:00:00
258
259 | 2011-05-04 00:00:00
260
261 | 2011-05-04 00:00:00
262
263
264 | 2012-07-09 00:00:00
265
266 | 2011-05-04 00:00:00
267 | 2011-09-08 00:00:00
268 | 2011-09-08 00:00:00
269 | 2011-03-22 00:00:00
270
271 | 2011-03-22 00:00:00
272 | 2011-03-22 00:00:00
273 | 2012-07-09 00:00:00
274 | 2011-09-08 00:00:00
275 | 2011-02-23 00:00:00
276 | 2011-03-22 00:00:00
277
278
279
280
281
282
283
284 | 2010-11-07 00:00:00
285
286
287
288 | 2010-11-07 00:00:00
289 | 2010-11-07 00:00:00
290
291 | 2010-11-07 00:00:00
292 | 2010-11-07 00:00:00
293 | 2011-02-14 00:00:00
294 | 2011-03-22 00:00:00
295 | 2011-03-22 00:00:00
296 | 2011-03-22 00:00:00
297
298
299
300
301 | 2011-05-04 00:00:00
302 | 2011-05-04 00:00:00
303 | 2011-03-22 00:00:00
304 | 2011-03-22 00:00:00
305 | 2012-07-09 00:00:00
306
307
308 | 2011-05-04 00:00:00
309 | 2011-03-22 00:00:00
310 | 2012-07-09 00:00:00
311 | 2012-07-09 00:00:00
312 | 2010-11-07 00:00:00
313 | 2012-07-09 00:00:00
314 | 2011-02-14 00:00:00
315 | 2012-07-09 00:00:00
316
317 | 2012-07-09 00:00:00
318 | 2011-02-23 00:00:00
319 | 2011-02-23 00:00:00
320 | 2011-02-23 00:00:00
321 | 2011-02-23 00:00:00
322 | 2011-02-23 00:00:00
323 | 2011-07-19 00:00:00
324 | 2011-02-23 00:00:00
325 | 2012-07-09 00:00:00
326
327
328
329
330
331
332
333
334
335
336
337
338 | 2011-02-23 00:00:00
339
340 | 2011-03-22 00:00:00
341
342
343
344
345
346 | 2011-03-22 00:00:00
347 | 2011-02-14 00:00:00