Spreadsheet: 538064d1505395475-creating-a-subset-of-data-from-a-larger-table-based-on-value-in-column-with-array-formula-ef
Sheet: All Records

Test Record No. | Date | Equip No. | Brand | Manufacturers stated Watts
18 | 2017-07-06 00:00:00 | 32 | [NAME] | 700
19 | 2017-07-06 00:00:00 | 57 | Matsui | 1000
20 | 2017-07-05 00:00:00 | 86 | Matsui | 800
21 | 2017-07-19 00:00:00 | 29 | [NAME] | 700
22 | 2017-07-20 00:00:00 | 30 | [NAME] | 700
23 | 2017-07-19 00:00:00 | 39 | Panasonic | 800
26 | 2017-07-20 00:00:00 | 38 | Panasonic | 900
27 | 2017-07-24 00:00:00 | 58 | Matsui | 1000
28 | 2017-07-25 00:00:00 | 36 | Panasonic | 900
29 | 2017-07-26 00:00:00 | 35 | Sharp | 900
30 | 2017-07-26 00:00:00 | 28 | [NAME] | 700
31 | 2017-07-27 00:00:00 | 34 | Sharp | 900
32 | 2017-07-28 00:00:00 | 32 | [NAME] | 700
37 | 2017-08-01 00:00:00 | 26 | Sharp | 750
34 | 2017-07-31 00:00:00 | 31 | [NAME] | 700
35 | 2017-08-01 00:00:00 | 29 | [NAME] | 700
36 | 2017-08-01 00:00:00 | 30 | [NAME] | 700
43 | 2017-08-09 00:00:00 | 26 | Sharp | 750
33 | 2017-07-31 00:00:00 | 27 | Sharp | 750
39 | 2017-08-04 00:00:00 | 24 | Panasonic | 800
40 | 2017-08-02 00:00:00 | 28 | [NAME] | 700
41 | 2017-08-04 00:00:00 | 27 | Sharp | 750
42 | 2017-07-18 00:00:00 | 41 | Panasonic | 800
38 | 2017-08-02 00:00:00 | 44 | Sharp | 750
44 | 2017-08-10 00:00:00 | 44 | Sharp | 750
45 | 2017-08-10 00:00:00 | 24 | Panasonic | 800
46 | 2017-08-10 00:00:00 | 22 | Panasonic | 800
47 | 2017-08-11 00:00:00 | 23 | Panasonic | 800
48 | 2017-08-11 00:00:00 | 57 | Matsui | 1000
49 | 2017-08-14 00:00:00 | 56 | Matsui | 1000
50 | 2017-08-14 00:00:00 | 41 | Panasonic | 800
51 | 2017-08-14 00:00:00 | 39 | Panasonic | 800
52 | 2017-08-15 00:00:00 | 38 | Panasonic | 900
53 | 2017-08-15 00:00:00 | 58 | Matsui | 1000
54 | 2017-08-15 00:00:00 | 36 | Panasonic | 900
55 | 2017-08-21 00:00:00 | 35 | Sharp | 900
56 | 2017-08-21 00:00:00 | 34 | Sharp | 900
57 | 2017-08-21 00:00:00 | 32 | [NAME] | 700
58 | 2017-08-30 00:00:00 | 31 | [NAME] | 700
59 | 2017-08-30 00:00:00 | 29 | [NAME] | 700
60 | 2017-08-30 00:00:00 | 30 | [NAME] | 700
61 | 2017-08-31 00:00:00 | 28 | [NAME] | 700
62 | 2017-08-31 00:00:00 | 27 | Sharp | 750
63 | 2017-08-31 00:00:00 | 44 | Sharp | 750
64 | 2017-09-01 00:00:00 | 24 | Panasonic | 800
65 | 2017-09-01 00:00:00 | 22 | Panasonic | 800
66 | 2017-09-01 00:00:00 | 23 | Panasonic | 800
67 | 2017-09-04 00:00:00 | 39 | Panasonic | 800
68 | 2017-09-04 00:00:00 | 56 | Matsui | 1000
69 | 2017-09-04 00:00:00 | 57 | Matsui | 1000
70 | 2017-09-05 00:00:00 | 41 | Panasonic | 800
71 | 2017-09-05 00:00:00 | 58 | Matsui | 1000
72 | 2017-09-05 00:00:00 | 32 | [NAME] | 700
73 | 2017-09-06 00:00:00 | 38 | Panasonic | 900
74 | 2017-09-06 00:00:00 | 31 | [NAME] | 700
75 | 2017-09-06 00:00:00 | 29 | [NAME] | 700
76 | 2017-09-07 00:00:00 | 32 | [NAME] | 700
77 | 2017-09-07 00:00:00 | 30 | [NAME] | 700
78 | 2017-09-07 00:00:00 | 28 | [NAME] | 700
79 | 2017-09-08 00:00:00 | 32 | [NAME] | 700
80 | 2017-09-08 00:00:00 | 57 | Matsui | 1000
81 | 2017-09-08 00:00:00 | 56 | Matsui | 1000
82 | 2017-09-08 00:00:00 | 22 | Panasonic | 800
83 | 2017-09-08 00:00:00 | 41 | Panasonic | 800
84 | 2017-09-08 00:00:00 | 58 | Matsui | 1000
85 | 2017-09-11 00:00:00 | 31 | [NAME] | 700
86 | 2017-09-11 00:00:00 | 34 | Sharp | 900
87 | 2017-09-11 00:00:00 | 23 | Panasonic | 800
88 | 2017-09-12 00:00:00 | 108 | Hotpoint | 750
89 | 2017-09-12 00:00:00 | 107 | Hotpoint | 750
90 | 2017-09-12 00:00:00 | 106 | Hotpoint | 750
91 | 2017-09-13 00:00:00 | 108 | Hotpoint | 750
92 | 2017-09-13 00:00:00 | 107 | Hotpoint | 750
93 | 2017-09-13 00:00:00 | 106 | Hotpoint | 750