Spreadsheet: 860368d1708496525-formula-to-count-unique-combinations-across-3-columns-6columncount-ans1
Sheet: Sheet1

First | Second | Third | Fourth | Fifth | Sixth
22551 | 22552 | 22845 | 20931 | L8699 | S9999 |  |  |  |  |  |  |  |  |  | 22551 | 22552 | 22845 | 20931 | L8699 | S9999 | 1 |  |  | 22551 | 22845 | 20931 | S9999 | 1
22551 | 22552 | 22853 | 22853 | 20930 | L8699 |  |  |  |  |  |  |  |  | Combination 2 | 22551 | 22552 | 22853 | 22853 | 20930 | L8699 | 1 |  | Combination 2 | 22551 | 22853 | 22853 | L8699 | 1
22551 | 22552 | 22853 | 22853 | 22845 | 20930 |  |  |  |  |  |  |  |  | Combination 3 | 22551 | 22552 | 22853 | 22853 | 22845 | 20930 | 6 |  | Combination 3 | 22551 | 22853 | 22853 | 20930 | 6
22551 | 22552 | 22853 | 22853 | 22845 | 20930 |  |  |  |  |  |  |  |  | Combination 4 | 22551 | 22552 | 22853 | 22853 | 22845 | 20931 | 1 |  | Combination 4 | 22551 | 22853 | 22853 | 20931 | 1
22551 | 22552 | 22853 | 22853 | 22845 | 20930 |  |  |  |  |  |  |  |  | Combination 5 | 22551 | 22552 | 22853 | 22853 | 22845 | C1713 | 1 |  | Combination 5 | 22551 | 22853 | 22853 | C1713 | 1
22551 | 22552 | 22853 | 22853 | 22845 | 20930 |  |  |  |  |  |  |  |  | Combination 6 | 22551 | 22853 | 20930 | C1776 | C1762 |  | 1 |  | Combination 6 | 22551 | 20930 | C1776 |  | 1
22551 | 22552 | 22853 | 22853 | 22845 | 20930 |  |  |  |  |  |  |  |  | Combination 7 | 22551 | 22853 | 22845 | 20930 | C1762 | C1831 | 1 |  | Combination 7 | 22551 | 22845 | 20930 | C1831 | 1
22551 | 22552 | 22853 | 22853 | 22845 | 20930 |  |  |  |  |  |  |  |  | Combination 8 | 22551 | 22853 | 22845 | 20931 | 20930 | L8699 | 1 |  | Combination 8 | 22551 | 22845 | 20931 | L8699 | 1
22551 | 22552 | 22853 | 22853 | 22845 | 20931 |  |  |  |  |  |  |  |  | Combination 9 | 22551 | 22853 | 22853 | 22552 | 22845 | 20930 | 1 |  | Combination 9 | 22551 | 22853 | 22552 | 20930 | 1
22551 | 22552 | 22853 | 22853 | 22845 | C1713 |  |  |  |  |  |  |  |  | Combination 10 | 22551 | 22853 | 22853 | 22845 | 20930 | L8699 | 1 |  | Combination 10 | 22551 | 22853 | 22845 | L8699 | 1
22551 | 22853 | 20930 | C1776 | C1762 |  |  |  |  |  |  |  |  |  | Combination 11 | 22551 | 22853 | 22853 | 22845 | 22552 | 20930 | 1 |  | Combination 11 | 22551 | 22853 | 22845 | 20930 | 1
22551 | 22853 | 22845 | 20930 | C1762 | C1831 |  |  |  |  |  |  |  |  | Combination 12 | 22630 | 22630 | 22840 | 20930 | 20936 | L8699 | 1 |  | Combination 12 | 22630 | 22840 | 20930 | L8699 | 2
22551 | 22853 | 22845 | 20931 | 20930 | L8699 |  |  |  |  |  |  |  |  | Combination 13 | 22630 | 22840 | 20936 | 20930 | L8699 | S9999 | 1 |  | Combination 13 | 22630 | 20936 | 20930 | S9999 | 1
22551 | 22853 | 22853 | 22552 | 22845 | 20930 |  |  |  |  |  |  |  |  | Combination 14 | 22630 | 22853 | 22840 | 20930 | 20936 | L8699 | 1 |  | Combination 14 | 22630 | 22853 | 22840 | 20930 | 1
22551 | 22853 | 22853 | 22845 | 20930 | L8699 |  |  |  |  |  |  |  |  | Combination 15 | 22630 | 63047 | 22853 | 22840 | 20936 | 20930 | 1 |  | Combination 15 | 22633 | 22853 | 63052 | 20936 | 1
22551 | 22853 | 22853 | 22845 | 22552 | 20930 |  |  |  |  |  |  |  |  | Combination 16 | 22633 | 22840 | 22853 | 63052 | 20930 | 20936 | 1 |  | Combination 16 | 22633 | 22840 | 20930 | L8699 | 1
22630 | 22630 | 22840 | 20930 | 20936 | L8699 |  |  |  |  |  |  |  |  | Combination 17 | 22633 | 22853 | 22840 | 20930 | 20936 | L8699 | 1 |  | Combination 17 | 22633 | 22840 | 20936 | L8699 | 1
22630 | 22840 | 20936 | 20930 | L8699 | S9999 | =LET(a,B3:B18&","&C3:C18&","&D3:D18,b,UNIQUE(a),c,TEXTSPLIT(TEXTJOIN(";",TRUE,b),",",";",TRUE),d,MMULT(1*(b=TRANSPOSE(a)),1*(a<>"")),e,"Combination "&SEQUENCE(COUNTA(b)),HSTACK(e,c,d)) |  |  |  |  |  |  |  | Combination 18 | 22633 | 22853 | 22840 | 20936 | 20930 | L8699 | 1 |  | Combination 18 | 22856 | 22845 | 22853 |  | 1
22630 | 22853 | 22840 | 20930 | 20936 | L8699 |  |  |  |  |  |  |  |  | Combination 19 | 22856 | 22551 | 22845 | 22853 |  |  | 1 |  | Combination 19 | 22856 | 20936 | 20930 |  | 1
22630 | 63047 | 22853 | 22840 | 20936 | 20930 |  |  |  |  |  |  |  |  | Combination 20 | 22856 | 22853 | 20936 | 20930 | L8699 |  | 1 |  | Combination 20 | 22856 | L8699 | S9999 |  | 3
22633 | 22840 | 22853 | 63052 | 20930 | 20936 |  |  |  |  |  |  |  |  | Combination 21 | 22856 | 22858 | L8699 | S9999 |  |  | 3 |  | Combination 21 | 22856 | L8699 |  |  | 1
22633 | 22853 | 22840 | 20930 | 20936 | L8699 |  |  |  |  |  |  |  |  | Combination 22 | 22856 | 22858 | L8699 |  |  |  | 1 |  | Combination 22 | 22856 | S9999 |  |  | 4
22633 | 22853 | 22840 | 20936 | 20930 | L8699 |  |  |  |  |  |  |  |  | Combination 23 | 22856 | L8699 | S9999 |  |  |  | 4 |  | Combination 23 | 22856 |  |  |  | 2
22856 | 22551 | 22845 | 22853 |  |  |  |  |  |  |  |  |  |  | Combination 24 | 22856 | L8699 |  |  |  |  | 2 |  | Combination 24 | 63020 | 22830 | S9999 |  | 1
22856 | 22853 | 20936 | 20930 | L8699 |  |  |  |  |  |  |  |  |  | Combination 25 | 63020 | 63035 | 22830 | S9999 |  |  | 1 |  | Combination 25 | 63020 | 63035 | 22830 |  | 1
22856 | 22858 | L8699 | S9999 |  |  |  |  |  |  |  |  |  |  | Combination 26 | 63020 | 63035 | 63035 | 22830 | S9999 |  | 1 |  | Combination 26 | 63020 | 63035 | S9999 |  | 1
22856 | 22858 | L8699 | S9999 |  |  |  |  |  |  |  |  |  |  | Combination 27 | 63020 | 63035 | 63035 | S9999 |  |  | 1 |  | Combination 27 | 63020 | S9999 |  |  | 1
22856 | 22858 | L8699 | S9999 |  |  |  |  |  |  |  |  |  |  | Combination 28 | 63020 | 63035 | S9999 |  |  |  | 1 |  | Combination 28 | 63030 | 63047 | L8699 |  | 1
22856 | 22858 | L8699 |  |  |  |  |  |  |  |  |  |  |  | Combination 29 | 63030 | 22899 | 63047 | L8699 | S9999 |  | 1 |  | Combination 29 | 63030 | 69990 | L8699 |  | 1
22856 | L8699 | S9999 |  |  |  |  |  |  |  |  |  |  |  | Combination 30 | 63030 | 22899 | 69990 | L8699 | S9999 |  | 1 |  | Combination 30 | 63030 | L8699 | S9999 |  | 7
22856 | L8699 | S9999 |  |  |  |  |  |  |  |  |  |  |  | Combination 31 | 63030 | 22899 | L8699 | S9999 |  |  | 6 |  | Combination 31 | 63030 | L8699 |  |  | 2
22856 | L8699 | S9999 |  |  |  |  |  |  |  |  |  |  |  | Combination 32 | 63030 | 22899 | L8699 |  |  |  | 2 |  | Combination 32 | 63030 | S9999 |  |  | 3
22856 | L8699 | S9999 |  |  |  |  |  |  |  |  |  |  |  | Combination 33 | 63030 | 63035 | L8699 | S9999 |  |  | 1 |  | Combination 33 | 63030 |  |  |  | 14
22856 | L8699 |  |  |  |  |  |  |  |  |  |  |  |  | Combination 34 | 63030 | 69990 | S9999 |  |  |  | 1 |  | Combination 34 | 63042 | L8699 | S9999 |  | 1
22856 | L8699 |  |  |  |  |  |  |  |  |  |  |  |  | Combination 35 | 63030 | C9290 |  |  |  |  | 1 |  | Combination 35 | 63042 | S9999 |  |  | 1
63020 | 63035 | 22830 | S9999 |  |  |  |  |  |  |  |  |  |  | Combination 36 | 63030 | L8699 | S9999 |  |  |  | 1 |  | Combination 36 | 63042 |  |  |  | 1
63020 | 63035 | 63035 | 22830 | S9999 |  |  |  |  |  |  |  |  |  | Combination 37 | 63030 | L8699 |  |  |  |  | 1 |  | Combination 37 | 63045 | 63048 | S9999 |  | 1
63020 | 63035 | 63035 | S9999 |  |  |  |  |  |  |  |  |  |  | Combination 38 | 63030 | S9999 |  |  |  |  | 6 |  | Combination 38 | 63045 | S9999 |  |  | 1
63020 | 63035 | S9999 |  |  |  |  |  |  |  |  |  |  |  | Combination 39 | 63030 | V2790 | S9999 |  |  |  | 1 |  | Combination 39 | 63045 |  |  |  | 1
63030 | 22899 | 63047 | L8699 | S9999 |  |  |  |  |  |  |  |  |  | Combination 40 | 63030 |  |  |  |  |  | 6 |  | Combination 40 | 63047 | L8699 | S9999 |  | 4
63030 | 22899 | 69990 | L8699 | S9999 |  |  |  |  |  |  |  |  |  | Combination 41 | 63042 | 22899 | L8699 | S9999 |  |  | 1 |  | Combination 41 | 63047 | S9999 |  |  | 8
63030 | 22899 | L8699 | S9999 |  |  |  |  |  |  |  |  |  |  | Combination 42 | 63042 | C9399 | S9999 |  |  |  | 1 |  | Combination 42 | 63047 |  |  |  | 38
63030 | 22899 | L8699 | S9999 |  |  |  |  |  |  |  |  |  |  | Combination 43 | 63042 |  |  |  |  |  | 1 |  | Combination 43 | 63055 |  |  |  | 1
63030 | 22899 | L8699 | S9999 |  |  |  |  |  |  |  |  |  |  | Combination 44 | 63045 | 63048 | 63048 | S9999 |  |  | 1 |  | Combination 44 | 63267 |  |  |  | 1
63030 | 22899 | L8699 | S9999 |  |  |  |  |  |  |  |  |  |  | Combination 45 | 63045 | 63048 | S9999 |  |  |  | 1 |  | Combination 45 | 64718 |  |  |  | 1
63030 | 22899 | L8699 | S9999 |  |  |  |  |  |  |  |  |  |  | Combination 46 | 63045 | 63048 |  |  |  |  | 1 |  | Combination 46 | C9757 | L8699 | S9999 |  | 1
63030 | 22899 | L8699 | S9999 |  |  |  |  |  |  |  |  |  |  | Combination 47 | 63047 | 63048 | L8699 | S9999 |  |  | 3 |  | Combination 47 | C9757 | 63048 | C1889 | S9999 | 2
63030 | 22899 | L8699 |  |  |  |  |  |  |  |  |  |  |  | Combination 48 | 63047 | 63048 | S9999 |  |  |  | 7 |  | Combination 48 | C9757 | C1889 | V2790 |  | 2
63030 | 22899 | L8699 |  |  |  |  |  |  |  |  |  |  |  | Combination 49 | 63047 | 63048 |  |  |  |  | 5 |  | Combination 49 | C9757 | V2790 | S9999 |  | 1
63030 | 63035 | L8699 | S9999 |  |  |  |  |  |  |  |  |  |  | Combination 50 | 63047 | 64999 | L8699 | S9999 |  |  | 1 |  | Combination 50 | C9757 | V2790 |  |  | 2
63030 | 69990 | S9999 |  |  |  |  |  |  |  |  |  |  |  | Combination 51 | 63047 | C9290 |  |  |  |  | 1 |  | Combination 51 | C9757 | S9999 |  |  | 3
63030 | C9290 |  |  |  |  |  |  |  |  |  |  |  |  | Combination 52 | 63047 | L8699 | S9999 |  |  |  | 1
63030 | L8699 | S9999 |  |  |  |  |  |  |  |  |  |  |  | Combination 53 | 63047 | L8699 |  |  |  |  | 2
63030 | L8699 |  |  |  |  |  |  |  |  |  |  |  |  | Combination 54 | 63047 | S9999 |  |  |  |  | 4
63030 | S9999 |  |  |  |  |  |  |  |  |  |  |  |  | Combination 55 | 63047 | V2790 |  |  |  |  | 2
63030 | S9999 |  |  |  |  |  |  |  |  |  |  |  |  | Combination 56 | 63047 |  |  |  |  |  | 24
63030 | S9999 |  |  |  |  |  |  |  |  |  |  |  |  | Combination 57 | 63055 |  |  |  |  |  | 1
63030 | S9999 |  |  |  |  |  |  |  |  |  |  |  |  | Combination 58 | 63267 |  |  |  |  |  | 1
63030 | S9999 |  |  |  |  |  |  |  |  |  |  |  |  | Combination 59 | 64718 |  |  |  |  |  | 1
63030 | S9999 |  |  |  |  |  |  |  |  |  |  |  |  | Combination 60 | C9757 | 63030 | L8699 | S9999 |  |  | 1
63030 | V2790 | S9999 |  |  |  |  |  |  |  |  |  |  |  | Combination 61 | C9757 | 63047 | 63048 | C1889 | V2790 | S9999 | 2
63030 |  |  |  |  |  |  |  |  |  |  |  |  |  | Combination 62 | C9757 | 63047 | C1889 | V2790 | S9999 |  | 1
63030 |  |  |  |  |  |  |  |  |  |  |  |  |  | Combination 63 | C9757 | 63047 | C1889 | V2790 |  |  | 1
63030 |  |  |  |  |  |  |  |  |  |  |  |  |  | Combination 64 | C9757 | C1889 | V2790 | S9999 |  |  | 1
63030 |  |  |  |  |  |  |  |  |  |  |  |  |  | Combination 65 | C9757 | C1889 | V2790 |  |  |  | 2
63030 |  |  |  |  |  |  |  |  |  |  |  |  |  | Combination 66 | C9757 | L8699 | S9999 |  |  |  | 3
63030
63042 | 22899 | L8699 | S9999
63042 | C9399 | S9999
63042
63045 | 63048 | 63048 | S9999
63045 | 63048 | S9999
63045 | 63048
63047 | 63048 | L8699 | S9999
63047 | 63048 | L8699 | S9999
63047 | 63048 | L8699 | S9999
63047 | 63048 | S9999
63047 | 63048 | S9999
63047 | 63048 | S9999
63047 | 63048 | S9999
63047 | 63048 | S9999
63047 | 63048 | S9999
63047 | 63048 | S9999
63047 | 63048
63047 | 63048
63047 | 63048
63047 | 63048
63047 | 63048
63047 | 64999 | L8699 | S9999
63047 | C9290
63047 | L8699 | S9999
63047 | L8699
63047 | L8699
63047 | S9999
63047 | S9999
63047 | S9999
63047 | S9999
63047 | V2790
63047 | V2790
63047
63047
63047
63047
63047
63047
63047
63047
63047
63047
63047
63047
63047
63047
63047
63047
63047
63047
63047
63047
63047
63047
63047
63047
63055
63267
64718
C9757 | 63030 | L8699 | S9999
C9757 | 63047 | 63048 | C1889 | V2790 | S9999
C9757 | 63047 | 63048 | C1889 | V2790 | S9999
C9757 | 63047 | C1889 | V2790 | S9999
C9757 | 63047 | C1889 | V2790
C9757 | C1889 | V2790 | S9999
C9757 | C1889 | V2790
C9757 | C1889 | V2790
C9757 | L8699 | S9999
C9757 | L8699 | S9999
C9757 | L8699 | S9999