Spreadsheet: 887033d1737120387-can-excel-produce-list-of-items-when-you-punch-in-a-value-and-doesnt-duplicate-example-data-etaf
Sheet: DATA

Code | Colourway | Date | Units Sold | RECEIVER STATE | TRANSACTION
CP0754 | Red | 2024-01-10 00:00:00 | 50 | QLD | 1
CP0754 | Blue | 2024-01-11 00:00:00 | 30 | NSW | 2
CP0754 | Green | 2024-01-12 00:00:00 | 20 | [NAME] | 3
CP0754 | Yellow | 2024-01-13 00:00:00 | 10 | NT | 4
CP0754 | Red | 2024-01-14 00:00:00 | 40 | WA | 5
CP0754 | Blue | 2024-01-15 00:00:00 | 25 | TAS | 6
CP0755 | Red | 2024-01-16 00:00:00 | 50 | QLD | 7
CP0755 | Blue | 2024-01-17 00:00:00 | 30 | NSW | 8
CP0755 | Sky | 2024-01-18 00:00:00 | 20 | [NAME] | 9
CP0755 | Purple | 2024-01-19 00:00:00 | 10 | NT | 10
CP0755 | Black | 2024-01-20 00:00:00 | 40 | WA | 11
CP0755 | Gold | 2024-01-21 00:00:00 | 25 | TAS | 12
CP1311 | Sky | 2024-01-22 00:00:00 | 50 | QLD | 13
CP1311 | Purple | 2024-01-23 00:00:00 | 30 | NSW | 14
CP1311 | Black | 2024-01-24 00:00:00 | 20 | [NAME] | 15
CP1311 | Gold | 2024-01-25 00:00:00 | 10 | NT | 16
CP1311 | Sky | 2024-01-26 00:00:00 | 40 | WA | 17
CP1311 | Purple | 2024-01-27 00:00:00 | 25 | TAS | 18
CP0754 | Black | 2024-01-28 00:00:00 | 10 | QLD | 19
CP0754 | Gold | 2024-01-29 00:00:00 | 11 | NSW | 20
CP0754 | Sky | 2024-01-30 00:00:00 | 12 | [NAME] | 21
CP0754 | Purple | 2024-01-31 00:00:00 | 13 | NT | 22
CP0754 | Black | 2024-02-01 00:00:00 | 14 | WA | 23
CP0754 | Gold | 2024-02-02 00:00:00 | 15 | TAS | 24
CP0755 | Sky | 2024-02-03 00:00:00 | 16 | QLD | 25
CP0755 | Blue | 2024-02-04 00:00:00 | 17 | NSW | 26
CP0755 | Green | 2024-02-05 00:00:00 | 18 | [NAME] | 27
CP0755 | Yellow | 2024-02-06 00:00:00 | 19 | NT | 28
CP0755 | Red | 2024-02-07 00:00:00 | 20 | WA | 29
CP0755 | Blue | 2024-02-08 00:00:00 | 21 | TAS | 30
CP1311 | Red | 2024-02-09 00:00:00 | 22 | QLD | 31
CP1311 | Blue | 2024-02-10 00:00:00 | 23 | NSW | 32
CP0754 | Red | 2024-02-11 00:00:00 | 24 | [NAME] | 33
CP0754 | Blue | 2024-02-12 00:00:00 | 25 | NT | 34
CP0754 | Green | 2024-02-13 00:00:00 | 26 | WA | 35
CP0754 | Yellow | 2024-02-14 00:00:00 | 27 | TAS | 36
CP0754 | Red | 2024-02-15 00:00:00 | 28 | QLD | 37
CP0754 | Blue | 2024-02-16 00:00:00 | 29 | NSW | 38
CP0755 | Red | 2024-02-17 00:00:00 | 30 | [NAME] | 39
CP0755 | Blue | 2024-02-18 00:00:00 | 31 | NT | 40
CP0755 | Green | 2024-02-19 00:00:00 | 32 | WA | 41
CP0755 | Yellow | 2024-02-20 00:00:00 | 33 | TAS | 42
CP0755 | Red | 2024-02-21 00:00:00 | 34 | QLD | 43
CP0755 | Blue | 2024-02-22 00:00:00 | 35 | NSW | 44
CP1311 | Red | 2024-02-23 00:00:00 | 36 | [NAME] | 45
CP1311 | Blue | 2024-02-24 00:00:00 | 37 | NT | 46
CP1311 | Green | 2024-02-25 00:00:00 | 38 | WA | 47
CP1311 | Yellow | 2024-02-26 00:00:00 | 39 | TAS | 48
CP1311 | Red | 2024-02-27 00:00:00 | 40 | QLD | 49
CP0754 | Red | 2024-02-28 00:00:00 | 41 | NSW | 50
CP0754 | Blue | 2024-02-29 00:00:00 | 42 | [NAME] | 51
CP0754 | Green | 2024-03-01 00:00:00 | 43 | NT | 52
CP0754 | Yellow | 2024-03-02 00:00:00 | 44 | WA | 53
CP0754 | Red | 2024-03-03 00:00:00 | 45 | TAS | 54
CP0754 | Blue | 2024-03-04 00:00:00 | 46 | QLD | 55
CP0755 | Red | 2024-03-05 00:00:00 | 47 | NSW | 56
CP0755 | Blue | 2024-03-06 00:00:00 | 48 | [NAME] | 57
CP0755 | Green | 2024-03-07 00:00:00 | 49 | NT | 58
CP0754 | Red | 2024-03-08 00:00:00 | 50 | WA | 59
CP0754 | Blue | 2024-03-09 00:00:00 | 51 | TAS | 60
CP0754 | Green | 2024-03-10 00:00:00 | 52 | QLD | 61
CP0754 | Yellow | 2024-03-11 00:00:00 | 53 | NSW | 62
CP0754 | Red | 2024-03-12 00:00:00 | 54 | [NAME] | 63
CP0754 | Blue | 2024-03-13 00:00:00 | 55 | NT | 64
CP0755 | Red | 2024-03-14 00:00:00 | 56 | WA | 65
CP0755 | Blue | 2024-03-15 00:00:00 | 57 | TAS | 66
CP0755 | Green | 2024-03-16 00:00:00 | 58 | QLD | 67
CP0755 | Yellow | 2024-03-17 00:00:00 | 59 | NSW | 68
CP0755 | Red | 2024-03-18 00:00:00 | 60 | [NAME] | 69
CP0755 | Blue | 2024-03-19 00:00:00 | 61 | NT | 70
CP0754 | Red | 2024-03-20 00:00:00 | 62 | WA | 71
CP0754 | Blue | 2024-03-21 00:00:00 | 63 | TAS | 72
CP0754 | Green | 2024-03-22 00:00:00 | 64 | QLD | 73
CP0754 | Yellow | 2024-03-23 00:00:00 | 65 | NSW | 74
CP0754 | Red | 2024-03-24 00:00:00 | 66 | [NAME] | 75
CP0754 | Blue | 2024-03-25 00:00:00 | 67 | NT | 76
CP0755 | Red | 2024-03-26 00:00:00 | 68 | WA | 77
CP0755 | Blue | 2024-03-27 00:00:00 | 69 | TAS | 78
CP0755 | Green | 2024-03-28 00:00:00 | 70 | QLD | 79
CT1207 | Black | 2024-01-10 00:00:00 | 50 | NSW | 80
CT1207 | Magenta | 2024-01-11 00:00:00 | 30 | [NAME] | 81
CT1207 | Teal | 2024-01-12 00:00:00 | 20 | NT | 82
CT1207 | Gold | 2024-01-13 00:00:00 | 10 | WA | 83
CT1208 | Black | 2024-01-14 00:00:00 |  | TAS | 84
CT1208 | Magenta | 2024-01-15 00:00:00 | 11 | QLD | 85
CT1208 | Teal | 2024-01-16 00:00:00 | 12 | NSW | 86
CT1208 | Gold | 2024-01-17 00:00:00 | 13 | [NAME] | 87
CT1207 | Black | 2024-01-18 00:00:00 |  | NT | 88
CT1207 | Magenta | 2024-01-19 00:00:00 | 14 | WA | 89
CT1207 | Teal | 2024-01-20 00:00:00 | 15 | TAS | 90
CT1207 | Gold | 2024-01-21 00:00:00 | 16 | QLD | 91
CT1208 | Black | 2024-01-22 00:00:00 |  | NSW | 92
CT1208 | Magenta | 2024-01-23 00:00:00 | 17 | [NAME] | 93
CT1208 | Teal | 2024-01-24 00:00:00 | 18 | NT | 94
CT1208 | Gold | 2024-01-25 00:00:00 | 19 | WA | 95
CT1207 | Black | 2024-01-26 00:00:00 |  | TAS | 96
CT1207 | Magenta | 2024-01-27 00:00:00 | 20 | QLD | 97
CT1207 | Teal | 2024-01-28 00:00:00 | 21 | NSW | 98
CT1207 | Gold | 2024-01-29 00:00:00 | 22 | [NAME] | 99
CT1208 | Black | 2024-01-30 00:00:00 |  | NT | 100
CT1208 | Magenta | 2024-01-31 00:00:00 | 23 | WA | 101
CT1208 | Teal | 2024-02-01 00:00:00 | 24 | TAS | 102
CT1208 | Gold | 2024-02-02 00:00:00 | 25 | QLD | 103
CT1207 | Black | 2024-02-03 00:00:00 |  | NSW | 104
CT1207 | Magenta | 2024-02-04 00:00:00 | 26 | [NAME] | 105
CT1207 | Teal | 2024-02-05 00:00:00 | 27 | NT | 106
CT1207 | Gold | 2024-02-06 00:00:00 | 28 | WA | 107
CT1208 | Black | 2024-02-07 00:00:00 |  | TAS | 108
CT1208 | Magenta | 2024-02-08 00:00:00 | 29 | QLD | 109
CT1208 | Teal | 2024-02-09 00:00:00 | 30 | NSW | 110
CT1208 | Gold | 2024-02-10 00:00:00 | 31 | [NAME] | 111
CT1207 | Black | 2024-02-11 00:00:00 |  | NT | 112
CT1207 | Magenta | 2024-02-12 00:00:00 | 32 | WA | 113
CT1207 | Teal | 2024-02-13 00:00:00 | 33 | TAS | 114
CT1207 | Gold | 2024-02-14 00:00:00 | 34 | QLD | 115
CT1208 | Black | 2024-02-15 00:00:00 |  | NSW | 116
CT1208 | Magenta | 2024-02-16 00:00:00 | 35 | [NAME] | 117
CT1208 | Teal | 2024-02-17 00:00:00 | 36 | NT | 118
CT1208 | Gold | 2024-02-18 00:00:00 | 37 | WA | 119
CT1207 | Black | 2024-02-19 00:00:00 |  | TAS | 120
CT1207 | Magenta | 2024-02-20 00:00:00 | 38 | QLD | 121
CT1207 | Teal | 2024-02-21 00:00:00 | 39 | NSW | 122
CT1207 | Gold | 2024-02-22 00:00:00 | 40 | [NAME] | 123
CT1208 | Black | 2024-02-23 00:00:00 |  | NT | 124
CT1208 | Magenta | 2024-02-24 00:00:00 | 41 | WA | 125
CT1208 | Teal | 2024-02-25 00:00:00 | 42 | TAS | 126
CT1208 | Gold | 2024-02-26 00:00:00 | 43 | QLD | 127
CT1207 | Black | 2024-02-27 00:00:00 |  | NSW | 128
CT1207 | Magenta | 2024-02-28 00:00:00 | 44 | [NAME] | 129
CT1207 | Teal | 2024-02-29 00:00:00 | 45 | NT | 130
CT1207 | Gold | 2024-03-01 00:00:00 | 46 | WA | 131
CT1208 | Black | 2024-03-02 00:00:00 |  | TAS | 132
CT1208 | Magenta | 2024-03-03 00:00:00 | 47 | QLD | 133
CT1208 | Teal | 2024-03-04 00:00:00 | 48 | NSW | 134
CT1208 | Gold | 2024-03-05 00:00:00 | 49 | [NAME] | 135
CT1207 | Black | 2024-03-06 00:00:00 |  | NT | 136
CT1207 | Magenta | 2024-03-07 00:00:00 | 50 | WA | 137
CT1207 | Teal | 2024-03-08 00:00:00 | 51 | TAS | 138
CT1207 | Gold | 2024-03-09 00:00:00 | 52 | QLD | 139
CT1208 | Black | 2024-03-10 00:00:00 |  | NSW | 140
CT1208 | Magenta | 2024-03-11 00:00:00 | 53 | [NAME] | 141
CT1208 | Teal | 2024-03-12 00:00:00 | 54 | NT | 142
CT1208 | Gold | 2024-03-13 00:00:00 | 55 | WA | 143
CT1207 | Black | 2024-03-14 00:00:00 |  | TAS | 144
CT1207 | Magenta | 2024-03-15 00:00:00 | 56 | QLD | 145
CT1207 | Teal | 2024-03-16 00:00:00 | 57 | NSW | 146
CT1207 | Gold | 2024-03-17 00:00:00 | 58 | [NAME] | 147
CT1208 | Black | 2024-03-18 00:00:00 |  | NT | 148
CT1208 | Magenta | 2024-03-19 00:00:00 | 59 | WA | 149
CT1208 | Teal | 2024-03-20 00:00:00 | 60 | TAS | 150
CT1208 | Gold | 2024-03-21 00:00:00 | 61 | QLD | 151
CT1207 | Black | 2024-03-22 00:00:00 |  | NSW | 152
CT1207 | Magenta | 2024-03-23 00:00:00 | 62 | [NAME] | 153
CT1207 | Teal | 2024-03-24 00:00:00 | 63 | NT | 154
CT1207 | Gold | 2024-03-25 00:00:00 | 64 | WA | 155
CT1208 | Black | 2024-03-26 00:00:00 |  | TAS | 156
CT1208 | Magenta | 2024-03-27 00:00:00 | 65 | QLD | 157
CT1208 | Teal | 2024-03-28 00:00:00 | 66 | NSW | 158
CT1208 | Gold | 2024-03-29 00:00:00 | 67 | [NAME] | 159
CT1207 | Black | 2024-03-30 00:00:00 |  | NT | 160
CT1207 | Magenta | 2024-03-31 00:00:00 | 68 | WA | 161
CT1207 | Teal | 2024-04-01 00:00:00 | 69 | TAS | 162
CT1207 | Gold | 2024-04-02 00:00:00 | 70 | QLD | 163
CT1208 | Black | 2024-04-03 00:00:00 |  | NSW | 164
CT1208 | Magenta | 2024-04-04 00:00:00 | 71 | [NAME] | 165
CT1208 | Teal | 2024-04-05 00:00:00 | 72 | NT | 166
CT1208 | Gold | 2024-04-06 00:00:00 | 73 | WA | 167
CT1207 | Black | 2024-04-07 00:00:00 |  | TAS | 168
CT1207 | Magenta | 2024-04-08 00:00:00 | 74 | QLD | 169
CT1207 | Teal | 2024-04-09 00:00:00 | 75 | NSW | 170
CT1207 | Gold | 2024-04-10 00:00:00 | 76 | [NAME] | 171
CT1208 | Black | 2024-04-11 00:00:00 |  | NT | 172
CT1208 | Magenta | 2024-04-12 00:00:00 | 77 | WA | 173
CT1208 | Teal | 2024-04-13 00:00:00 | 78 | TAS | 174
CT1208 | Gold | 2024-04-14 00:00:00 | 79 | QLD | 175
CT1207 | Black | 2024-04-15 00:00:00 |  | NSW | 176
CT1207 | Magenta | 2024-04-16 00:00:00 | 80 | [NAME] | 177
CT1207 | Teal | 2024-04-17 00:00:00 | 81 | NT | 178
CT1207 | Gold | 2024-04-18 00:00:00 | 82 | WA | 179
CT1208 | Black | 2024-04-19 00:00:00 |  | TAS | 180
CT1208 | Magenta | 2024-04-20 00:00:00 | 83 | QLD | 181
CT1208 | Teal | 2024-04-21 00:00:00 | 84 | NSW | 182
CT1208 | Gold | 2024-04-22 00:00:00 | 85 | [NAME] | 183
CT1207 | Black | 2024-04-23 00:00:00 |  | NT | 184
CT1207 | Magenta | 2024-04-24 00:00:00 | 86 | WA | 185
CT1207 | Teal | 2024-04-25 00:00:00 | 87 | TAS | 186
CT1207 | Gold | 2024-04-26 00:00:00 | 88 | QLD | 187
CT1208 | Black | 2024-04-27 00:00:00 |  | NSW | 188
CT1208 | Magenta | 2024-04-28 00:00:00 | 89 | [NAME] | 189
CT1208 | Teal | 2024-04-29 00:00:00 | 90 | NT | 190
CT1208 | Gold | 2024-04-30 00:00:00 | 91 | WA | 191
CT1207 | Black | 2024-05-01 00:00:00 |  | TAS | 192
CT1207 | Magenta | 2024-05-02 00:00:00 | 92 | QLD | 193
CT1207 | Teal | 2024-05-03 00:00:00 | 93 | NSW | 194
CT1207 | Gold | 2024-05-04 00:00:00 | 94 | [NAME] | 195
CT1208 | Black | 2024-05-05 00:00:00 |  | NT | 196
CT1208 | Magenta | 2024-05-06 00:00:00 | 95 | WA | 197
CT1208 | Teal | 2024-05-07 00:00:00 | 96 | TAS | 198
CT1208 | Gold | 2024-05-08 00:00:00 | 97 | QLD | 199
CT1207 | Black | 2024-05-09 00:00:00 |  | NSW | 200
CT1207 | Magenta | 2024-05-10 00:00:00 | 98 | [NAME] | 201
CT1207 | Teal | 2024-05-11 00:00:00 | 99 | NT | 202
CP0754 | Black | 2024-01-10 00:00:00 | 50 | WA | 203
CP0754 | Gold | 2024-01-11 00:00:00 | 30 | TAS | 204
CP0754 | Sky | 2024-01-12 00:00:00 | 20 | QLD | 205
CP0754 | Purple | 2024-01-13 00:00:00 | 10 | NSW | 206
CP0754 | Black | 2024-01-14 00:00:00 | 40 | [NAME] | 207
CP0754 | Gold | 2024-01-15 00:00:00 | 25 | NT | 208
CP0755 | Sky | 2024-01-16 00:00:00 | 50 | WA | 209
CP0755 | Purple | 2024-01-17 00:00:00 | 30 | TAS | 210
CP0755 | Black | 2024-01-18 00:00:00 | 20 | QLD | 211
CP0755 | Gold | 2024-01-19 00:00:00 | 10 | NSW | 212
CP0755 | Sky | 2024-01-20 00:00:00 | 40 | [NAME] | 213
CP0755 | Purple | 2024-01-21 00:00:00 | 25 | NT | 214
CP1311 | Black | 2024-01-22 00:00:00 | 50 | WA | 215
CP1311 | Gold | 2024-01-23 00:00:00 | 30 | TAS | 216
CP1311 | Sky | 2024-01-24 00:00:00 | 20 | QLD | 217
CP1311 | Purple | 2024-01-25 00:00:00 | 10 | NSW | 218
CP1311 | Black | 2024-01-26 00:00:00 | 40 | [NAME] | 219
CP1311 | Gold | 2024-01-27 00:00:00 | 25 | NT | 220
CP0754 | Sky | 2024-01-28 00:00:00 | 10 | WA | 221
CP0754 | Purple | 2024-01-29 00:00:00 | 11 | TAS | 222
CP0754 | Black | 2024-01-30 00:00:00 | 12 | QLD | 223
CP0754 | Gold | 2024-01-31 00:00:00 | 13 | NSW | 224
CP0754 | Sky | 2024-02-01 00:00:00 | 14 | [NAME] | 225
CP0754 | Purple | 2024-02-02 00:00:00 | 15 | NT | 226
CP0755 | Black | 2024-02-03 00:00:00 | 16 | WA | 227
CP0755 | Gold | 2024-02-04 00:00:00 | 17 | TAS | 228
CP0755 | Sky | 2024-02-05 00:00:00 | 18 | QLD | 229
CP0755 | Purple | 2024-02-06 00:00:00 | 19 | NSW | 230
CP0755 | Black | 2024-02-07 00:00:00 | 20 | [NAME] | 231
CP0755 | Gold | 2024-02-08 00:00:00 | 21 | NT | 232
CP1311 | Sky | 2024-02-09 00:00:00 | 22 | WA | 233
CP1311 | Purple | 2024-02-10 00:00:00 | 23 | TAS | 234
CP0754 | Black | 2024-02-11 00:00:00 | 24 | QLD | 235
CP0754 | Gold | 2024-02-12 00:00:00 | 25 | NSW | 236
CP0754 | Sky | 2024-02-13 00:00:00 | 26 | [NAME] | 237
CP0754 | Purple | 2024-02-14 00:00:00 | 27 | NT | 238
CP0754 | Black | 2024-02-15 00:00:00 | 28 | WA | 239
CP0754 | Gold | 2024-02-16 00:00:00 | 29 | TAS | 240
CP0755 | Sky | 2024-02-17 00:00:00 | 30 | QLD | 241
CP0755 | Purple | 2024-02-18 00:00:00 | 31 | NSW | 242
CP0755 | Black | 2024-02-19 00:00:00 | 32 | [NAME] | 243
CP0755 | Gold | 2024-02-20 00:00:00 | 33 | NT | 244
CP0755 | Sky | 2024-02-21 00:00:00 | 34 | WA | 245
CP0755 | Purple | 2024-02-22 00:00:00 | 35 | TAS | 246
CP1311 | Black | 2024-02-23 00:00:00 | 36 | QLD | 247
CP1311 | Gold | 2024-02-24 00:00:00 | 37 | NSW | 248
CP1311 | Sky | 2024-02-25 00:00:00 | 38 | [NAME] | 249
CP1311 | Purple | 2024-02-26 00:00:00 | 39 | NT | 250
CP1311 | Black | 2024-02-27 00:00:00 | 40 | WA | 251
CP0754 | Gold | 2024-02-28 00:00:00 | 41 | TAS | 252
CP0754 | Sky | 2024-02-29 00:00:00 | 42 | QLD | 253
CP0754 | Purple | 2024-03-01 00:00:00 | 43 | NSW | 254
CP0754 | Black | 2024-03-02 00:00:00 | 44 | [NAME] | 255
CP0754 | Gold | 2024-03-03 00:00:00 | 45 | NT | 256
CP0754 | Sky | 2024-03-04 00:00:00 | 46 | WA | 257
CP0755 | Purple | 2024-03-05 00:00:00 | 47 | TAS | 258
CP0755 | Black | 2024-03-06 00:00:00 | 48 | QLD | 259
CP0755 | Gold | 2024-03-07 00:00:00 | 49 | NSW | 260
CP0754 | Sky | 2024-03-08 00:00:00 | 50 | [NAME] | 261
CP0754 | Purple | 2024-03-09 00:00:00 | 51 | NT | 262
CP0754 | Black | 2024-03-10 00:00:00 | 52 | WA | 263
CP0754 | Gold | 2024-03-11 00:00:00 | 53 | TAS | 264
CP0754 | Sky | 2024-03-12 00:00:00 | 54 | QLD | 265
CP0754 | Purple | 2024-03-13 00:00:00 | 55 | NSW | 266
CP0755 | Black | 2024-03-14 00:00:00 | 56 | [NAME] | 267
CP0755 | Gold | 2024-03-15 00:00:00 | 57 | NT | 268
CP0755 | Sky | 2024-03-16 00:00:00 | 58 | WA | 269
CP0755 | Purple | 2024-03-17 00:00:00 | 59 | TAS | 270
CP0755 | Black | 2024-03-18 00:00:00 | 60 | QLD | 271
CP0755 | Gold | 2024-03-19 00:00:00 | 61 | NSW | 272
CP0754 | Sky | 2024-03-20 00:00:00 | 62 | [NAME] | 273
CP0754 | Purple | 2024-03-21 00:00:00 | 63 | NT | 274
CP0754 | Black | 2024-03-22 00:00:00 | 64 | WA | 275
CP0754 | Gold | 2024-03-23 00:00:00 | 65 | TAS | 276
CP0754 | Sky | 2024-03-24 00:00:00 | 66 | QLD | 277
CP0754 | Purple | 2024-03-25 00:00:00 | 67 | NSW | 278
CP0755 | Black | 2024-03-26 00:00:00 | 68 | [NAME] | 279
CP0755 | Gold | 2024-03-27 00:00:00 | 69 | NT | 280
CP0755 | Sky | 2024-03-28 00:00:00 | 70 | WA | 281