Spreadsheet: 753164d1635272287-formula-to-get-unique-list-of-values-from-multiple-columns-in-a-table-fx-to-get-unique-list-from-multi-cols4
Sheet: Sheet1

Comma-delim. List | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26
AB_01
AB_02 | AB_02
AB_04, AB_05, AB_06, AB_8.19, AB_8.20, AB_08, AB_21, [NAME], [NAME], [NAME], AB_8.30, [NAME], AB_8.28, AB_8.26, AB_8.21, AB_8.31, AB_8.32, [NAME], AB_8.34, [NAME], AB_8.36, AB_8.44, AB_8.37, AB_8.39, AB_8.24, AB_8.10-02 | AB_04 | AB_05 | AB_06 | AB_8.19 | AB_8.20 | [NAME] | AB_21 | AB_8.22 | AB_8.25 | AB_8.27 | [NAME] | AB_8.29 | AB_8.28 | AB_8. | 26 | AB_8.21 | AB_8.31 | AB_8.32 | AB_8.33 | AB_8.34 | AB_8.35 | AB_8.36 | AB_8.44 | AB_8.37 | AB_8.39 | AB_8.24
AB_07 | AB_07
AB_03, AB_06, AB_8.15-01, AB_8.15-02, AB_8.15-03 | AB_03 | AB_06 | AB_8.15-01 | AB_8.15-02 | AB_8.15-03
https://www.excelforum.com/excel-formulas-and-functions/1361531-formula-to-get-unique-list-of-values-from-multiple-columns-in-a-table.html |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Colour |  | drop-down list
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blue |  | Colour
 | Manual (incomplete) |  | Array
 | Unique List |  | Incl. duplicates |  | Unique list, sorted |  | Sorted, direct from CDL (table not required) |  |  |  |  |  |  |  | Reference List | Colour | Expected | Actual | Status |  | Conditional |  |  |  | Blue
 | AB_01 |  |  |  |  |  |  |  |  |  |  |  |  |  | AB_01 | Black | 2021-05-10 00:00:00 | 2021-05-11 00:00:00 | LATE |  |  |  |  |  | Green
 | AB_02 |  | AB_02 |  | AB_01 |  | AB_02 | AB_02 |  |  |  |  |  |  | AB_02 | White | 2021-02-10 00:00:00 | 2021-02-11 00:00:00 | LATE |  | AB_15 |  |  |  | White
 | AB_04 |  | AB_04 |  | AB_02 |  | AB_03 | AB_03 |  |  |  |  |  |  | AB_03 | Yellow | 2021-04-06 00:00:00 | 2021-04-06 00:00:00 |  |  | AB_19 |  |  |  | Yellow
 | AB_05 |  | AB_05 |  | AB_03 |  | AB_04 | AB_04 |  |  |  |  |  |  | AB_04 | Yellow | 2021-08-28 00:00:00 | 2021-08-27 00:00:00
 | AB_06 |  | AB_06 |  | AB_04 |  | AB_05 | AB_05 |  |  |  |  |  |  | AB_05 | Yellow | 2021-05-09 00:00:00 | 2021-05-11 00:00:00 | LATE
 | AB_8.19 |  | AB_8.19 |  | AB_05 |  | AB_06 | AB_06 |  |  |  |  |  |  | AB_06 | Yellow | 2021-03-23 00:00:00 | 2021-03-22 00:00:00
 | AB_20 |  | AB_8.20 |  | AB_06 |  | AB_07 | AB_07 |  |  |  |  |  |  | AB_07 | Yellow | 2021-02-26 00:00:00 | 2021-02-27 00:00:00 | LATE
 | [NAME] |  | [NAME] |  | AB_07 |  | [NAME] | [NAME] |  |  |  |  |  |  | [NAME] | Yellow | 2021-09-05 00:00:00 | 2021-09-05 00:00:00
 | AB_21 |  | AB_21 |  | [NAME] |  | AB_21 | AB_21 |  |  |  |  |  |  | AB_09 | Green | 2021-10-22 00:00:00 | 2021-10-22 00:00:00
 | AB_8.22 |  | AB_8.22 |  | AB_21 |  | AB_8.10-02 | AB_8.10-02 |  |  |  |  |  |  | AB_10 | Blue | 2021-10-21 00:00:00 | 2021-10-22 00:00:00 | LATE
 | AB_8.25 |  | AB_8.25 |  | AB_8. |  | AB_8.15-01 | AB_8.15-01 |  |  |  |  |  |  | AB_11 | Blue | 2021-12-11 00:00:00 | 2021-12-10 00:00:00
 | AB_8.27 |  | AB_8.27 |  | AB_8.15-01 |  | AB_8.15-02 | AB_8.15-02 |  |  |  |  |  |  | AB_12 | Blue | 2021-07-14 00:00:00 | 2021-07-14 00:00:00
 | [NAME] |  | [NAME] |  | AB_8.15-02 |  | AB_8.15-03 | AB_8.15-03 |  |  |  |  |  |  | AB_13 | Blue | 2021-11-04 00:00:00 | 2021-11-04 00:00:00
 | AB_8.29 |  | AB_8.29 |  | AB_8.15-03 |  | AB_8.19 | AB_8.19 |  |  |  |  |  |  | AB_14 | Green | 2021-06-17 00:00:00 | 2021-06-18 00:00:00 | LATE
 | AB_8.28 |  | AB_8.28 |  | AB_8.19 |  | AB_8.20 | AB_8.20 |  |  |  |  |  |  | AB_15 | Blue | 2021-03-14 00:00:00 | 2021-03-15 00:00:00 | LATE
 | AB_8.26 |  | AB_8. |  | AB_8.20 |  | AB_8.21 | AB_8.21 |  |  |  |  |  |  | [NAME] | Blue | 2021-11-19 00:00:00 | 2021-11-19 00:00:00
 | AB_8.21 |  | 26 |  | AB_8.21 |  | AB_8.22 | AB_8.22 |  |  |  |  |  |  | [NAME] | Blue | 2021-10-19 00:00:00 | 2021-10-19 00:00:00
 | AB_8.31 |  | AB_8.21 |  | AB_8.22 |  | AB_8.24 | AB_8.24 |  |  |  |  |  |  | AB_18 | Green | 2021-03-29 00:00:00 | 2021-03-30 00:00:00 | LATE
 | AB_8.32 |  | AB_8.31 |  | AB_8.24 |  | AB_8.25 | AB_8.25 |  |  |  |  |  |  | AB_19 | Blue | 2021-11-23 00:00:00 | 2021-11-24 00:00:00 | LATE
 | AB_8.33 |  | AB_8.32 |  | AB_8.25 |  | AB_8.26 | AB_8.26 |  |  |  |  |  |  | AB_21 | Black | 2021-11-08 00:00:00 | 2021-11-08 00:00:00
 | AB_8.34 |  | AB_8.33 |  | AB_8.27 |  | AB_8.27 | AB_8.27 |  |  |  |  |  |  | AB_8.10-02 | Yellow | 2021-04-14 00:00:00 | 2021-04-13 00:00:00
 | AB_8.35 |  | AB_8.34 |  | AB_8.28 |  | AB_8.28 | AB_8.28
 | AB_8.36 |  | AB_8.35 |  | AB_8.29 |  | AB_8.29 | AB_8.29
 | AB_8.44 |  | AB_8.36 |  | [NAME] |  | [NAME] | [NAME]
 | AB_8.37 |  | AB_8.44 |  | AB_8.31 |  | AB_8.31 | AB_8.31
 | AB_8.39 |  | AB_8.37 |  | AB_8.32 |  | AB_8.32 | AB_8.32
 | AB_8.24 |  | AB_8.39 |  | AB_8.33 |  | AB_8.33 | AB_8.33
 | AB_8.10-02 |  | AB_8.24 |  | AB_8.34 |  | AB_8.34 | AB_8.34
 | AB_07 |  | AB_07 |  | AB_8.35 |  | AB_8.35 | AB_8.35
 | AB_03 |  | AB_03 |  | AB_8.36 |  | AB_8.36 | AB_8.36
 | AB_8.20 |  | AB_06 |  | AB_8.37 |  | AB_8.37 | AB_8.37
 |  |  | AB_8.15-01 |  | AB_8.39 |  | AB_8.39 | AB_8.39
 |  |  | AB_8.15-02 |  | AB_8.44 |  | AB_8.44 | AB_8.44
 |  |  | AB_8.15-03