Spreadsheet: 752738d1634916365-formula-to-get-unique-list-of-values-from-multiple-columns-in-a-table-fx-to-get-unique-list-from-multi-cols2
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_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_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_8.10-02
AB_07
AB_03, AB_06, AB_8.15-01, AB_8.15-02, AB_8.15-03 |  | AB_06 | AB_8.15-01 | AB_8.15-02 | AB_8.15-03
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Black
 | Manual (incomplete) |  | Array
 | Unique List |  | Incl. duplicates |  | Unique list |  | Sorted |  | Sorted, w/o table |  |  |  |  |  |  |  |  | Reference List | Colour | Date |  | Conditional
 | AB_01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AB_01 | Black | 2021-05-10 00:00:00
 | AB_02 |  | AB_02 |  | AB_02 |  | AB_02 |  | AB_02 |  |  |  |  |  |  |  |  | AB_02 | White | 2021-02-10 00:00:00 |  | AB_21
 | AB_04 |  | AB_04 |  | AB_04 |  | AB_03 |  | AB_03 |  |  |  |  |  |  |  |  | AB_03 | Yellow | 2021-04-06 00:00:00 |  | AB_8.20
 | AB_05 |  | AB_05 |  | AB_05 |  | AB_04 |  | AB_04 |  |  |  |  |  |  |  |  | AB_04 | Yellow | 2021-08-28 00:00:00 |  | AB_8.21
 | AB_06 |  | AB_06 |  | AB_06 |  | AB_05 |  | AB_05 |  |  |  |  |  |  |  |  | AB_05 | Yellow | 2021-05-09 00:00:00 |  | AB_8.28
 | AB_8.19 |  | AB_8.19 |  | AB_8.19 |  | AB_06 |  | AB_06 |  |  |  |  |  |  |  |  | AB_06 | Yellow | 2021-03-23 00:00:00
 | AB_20 |  | AB_8.20 |  | AB_8.20 |  | AB_07 |  | AB_07 |  |  |  |  |  |  |  |  | AB_07 | Yellow | 2021-02-28 00:00:00
 | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] | Yellow | 2021-09-05 00:00:00
 | AB_21 |  | AB_21 |  | AB_21 |  | AB_21 |  | AB_21 |  |  |  |  |  |  |  |  | AB_09 | Green | 2021-10-22 00:00:00
 | AB_8.22 |  | AB_8.22 |  | AB_8.22 |  | AB_8.10-02 |  | AB_8.10-02 |  |  |  |  |  |  |  |  | AB_10 | Blue | 2021-10-21 00:00:00
 | AB_8.25 |  | AB_8.25 |  | AB_8.25 |  | AB_8.15-01 |  | AB_8.15-01 |  |  |  |  |  |  |  |  | AB_11 | Blue | 2021-12-11 00:00:00
 | AB_8.27 |  | AB_8.27 |  | AB_8.27 |  | AB_8.15-02 |  | AB_8.15-02 |  |  |  |  |  |  |  |  | AB_12 | Blue | 2021-07-14 00:00:00
 | [NAME] |  | [NAME] |  | [NAME] |  | AB_8.15-03 |  | AB_8.15-03 |  |  |  |  |  |  |  |  | AB_13 | Blue | 2021-11-04 00:00:00
 | AB_8.29 |  | AB_8.29 |  | AB_8.29 |  | AB_8.19 |  | AB_8.19 |  |  |  |  |  |  |  |  | AB_14 | Green | 2021-06-17 00:00:00
 | AB_8.28 |  | AB_8.28 |  | AB_8.28 |  | AB_8.20 |  | AB_8.20 |  |  |  |  |  |  |  |  | AB_15 | Blue | 2021-03-14 00:00:00
 | AB_8.26 |  | AB_8.26 |  | AB_8.26 |  | AB_8.21 |  | AB_8.21 |  |  |  |  |  |  |  |  | [NAME] | Blue | 2021-11-19 00:00:00
 | AB_8.21 |  | AB_8.21 |  | AB_8.21 |  | AB_8.22 |  | AB_8.22 |  |  |  |  |  |  |  |  | [NAME] | Blue | 2021-10-19 00:00:00
 | AB_8.31 |  | AB_8.31 |  | AB_8.31 |  | AB_8.24 |  | AB_8.24 |  |  |  |  |  |  |  |  | AB_18 | Green | 2021-03-29 00:00:00
 | AB_8.32 |  | AB_8.32 |  | AB_8.32 |  | AB_8.25 |  | AB_8.25 |  |  |  |  |  |  |  |  | AB_19 | Blue | 2021-11-23 00:00:00
 | AB_8.33 |  | AB_8.33 |  | AB_8.33 |  | AB_8.26 |  | AB_8.26 |  |  |  |  |  |  |  |  | AB_21 | Black | 2021-11-08 00:00:00
 | AB_8.34 |  | AB_8.34 |  | AB_8.34 |  | AB_8.27 |  | AB_8.27 |  |  |  |  |  |  |  |  | AB_8.10-02 | Yellow | 2021-04-14 00:00:00
 | AB_8.35 |  | AB_8.35 |  | AB_8.35 |  | AB_8.28 |  | AB_8.28 |  |  |  |  |  |  |  |  | AB_8.15-01 | Yellow | 2021-11-27 00:00:00
 | AB_8.36 |  | AB_8.36 |  | AB_8.36 |  | AB_8.29 |  | AB_8.29 |  |  |  |  |  |  |  |  | AB_8.15-02 | Yellow | 2021-08-13 00:00:00
 | AB_8.44 |  | AB_8.44 |  | AB_8.44 |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  | AB_8.15-03 | Yellow | 2021-12-05 00:00:00
 | AB_8.37 |  | AB_8.37 |  | AB_8.37 |  | AB_8.31 |  | AB_8.31 |  |  |  |  |  |  |  |  | AB_8.19 | Yellow | 2021-10-08 00:00:00
 | AB_8.39 |  | AB_8.39 |  | AB_8.39 |  | AB_8.32 |  | AB_8.32 |  |  |  |  |  |  |  |  | AB_8.20 | Black | 2021-06-01 00:00:00
 | AB_8.24 |  | AB_8.24 |  | AB_8.24 |  | AB_8.33 |  | AB_8.33 |  |  |  |  |  |  |  |  | AB_8.21 | Black | 2021-03-12 00:00:00
 | AB_8.10-02 |  | AB_8.10-02 |  | AB_8.10-02 |  | AB_8.34 |  | AB_8.34 |  |  |  |  |  |  |  |  | AB_8.22 | Yellow | 2021-04-10 00:00:00
 | AB_07 |  | AB_07 |  | AB_07 |  | AB_8.35 |  | AB_8.35 |  |  |  |  |  |  |  |  | AB_8.24 | Yellow | 2021-07-09 00:00:00
 | AB_03 |  | AB_03 |  | AB_03 |  | AB_8.36 |  | AB_8.36 |  |  |  |  |  |  |  |  | AB_8.25 | White | 2021-08-22 00:00:00
 | AB_8.20 |  | AB_06 |  | AB_8.15-01 |  | AB_8.37 |  | AB_8.37 |  |  |  |  |  |  |  |  | AB_8.26 | Yellow | 2021-11-16 00:00:00
 |  |  | AB_8.15-01 |  | AB_8.15-02 |  | AB_8.39 |  | AB_8.39 |  |  |  |  |  |  |  |  | AB_8.27 | Yellow | 2021-04-07 00:00:00
 |  |  | AB_8.15-02 |  | AB_8.15-03 |  | AB_8.44 |  | AB_8.44 |  |  |  |  |  |  |  |  | AB_8.28 | Black | 2021-08-31 00:00:00
 |  |  | AB_8.15-03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AB_8.29 | Yellow | 2021-04-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Yellow | 2021-09-12 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AB_8.31 | Yellow | 2021-01-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AB_8.32 | Yellow | 2021-03-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AB_8.33 | Yellow | 2021-04-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AB_8.34 | Yellow | 2021-09-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AB_8.35 | Yellow | 2021-07-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AB_8.36 | Yellow | 2021-11-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AB_8.37 | Yellow | 2021-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AB_8.39 | Yellow | 2021-12-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AB_8.44 | Yellow | 2021-08-23 00:00:00