test.py

#first need to =CONCATENATE(TRANSPOSE($A$6:$A$205)&",") the numbers in excel

#from ChatGPT
#define four sets of numbers
set1 = [Z1745743684_1_T2,	Z973880224_1_T1,	Z1745743684_1_T1,	Z2023371400_1_T1,	Z2023371400_1_T4,	Z2023371400_1_T5,	Z2176833252_1_T1,	Z846031298_1_T3,	Z1945509380_1_T1,	Z1972658692_1_T2,	Z1972658692_1_T3,	Z1972658692_1_T7,	Z1972658692_1_T8,	Z2176833252_1_T3,	Z2465930885_1_T1,	Z2465930885_1_T2,	Z2465930885_1_T3,	Z1004115458_1_T3,	Z332932512_1_T2,	Z744073076_1_T1,	Z1116542599_1_T3,	Z1177736698_1_T5,	Z1613911188_1_T1,	Z1616631575_1_T1,	Z1616631575_1_T3,	Z1677961101_1_T5,	Z1677968354_1_T2,	Z1945504285_1_T1,	Z1945509380_1_T3,	Z2119085548_1_T5,	Z2175595734_1_T2,	Z2175595734_1_T5,	Z846031298_1_T2,	Z973880222_1_T1,	Z973880222_1_T2,	Z982106746_1_T2,	Z1095039880_1_T2,	Z1116542599_1_T1,	Z1226933665_1_T1,	Z1232081597_1_T2,	Z1410515685_1_T2,	Z1197690671_2_T1,	Z1677959326_1_T2,	Z1677961101_1_T3,	Z1677967537_1_T2,	Z1919806298_2_T3,	Z1945504285_1_T3,	Z1945506832_1_T4,	Z2023371400_1_T2,	Z2074755684_1_T1,	Z2119085548_1_T3,	Z2164738935_1_T1,	Z2164738935_1_T5,	Z2273155724_1_T2,	Z846031298_1_T4,	Z973880224_1_T2,	Z1118540753_1_T2,	Z1118540753_2_T2,	Z1174989964_1_T2,	Z1177736698_1_T4,	Z1403811255_1_T1,	Z1423393101_1_T1,	Z1438682565_1_T4,	Z1443626120_1_T2,	Z1482496644_4_T1,	Z1490205118_1_T1,	Z1490205118_1_T3,	Z1127211280_1_T2,	Z1574594963_1_T1,	Z1616631575_1_T2,	Z1634579827_1_T1,	Z1634579827_2_T1,	Z1640887036_1_T1,	Z1677967537_1_T5,	Z1677968354_1_T5,	Z1720420073_1_T7,	Z1745877154_1_T4,	Z1049920648_1_T4,	Z1765288069_1_T2,	Z1765288069_1_T3,	Z1836065217_1_T1,	Z1919806298_2_T1,	Z1938133597_1_T1,	Z1945506832_2_T6,	Z1972658692_1_T4,	Z2023371400_1_T3,	Z2023371400_1_T6,	Z2023371400_2_T1,	Z2023371400_2_T5,	Z1910568204_1_T1,	Z2108120469_2_T2,	Z2113547221_1_T4,	Z2119085574_1_T3,	Z2164738935_1_T2,	Z2164738935_1_T3,	Z2164738935_1_T4,	Z2227338672_1_T5,	Z2227338672_2_T1,	Z2227338672_2_T5,	Z2227340170_1_T1]
set2 = [Z1438682376_1_T4,	Z1982146880_1_T1,	Z1982146880_1_T2,	Z1438682376_1_T1,	Z1438682376_1_T2,	Z1438880238_1_T4,	Z1982146880_1_T3,	Z1438880238_1_T2,	Z1438682376_1_T3,	Z1447774111_1_T1,	Z1447774111_1_T2,	Z927972426_1_T4,	Z1257370428_2_T1,	Z1326519098_2_T2,	Z1455091621_1_T1,	Z1006546360_1_T2,	Z1174989964_1_T1,	Z1257370428_2_T2,	Z1438880238_1_T1,	Z1518697318_1_T2,	Z1518697318_1_T3,	Z1518704001_1_T2,	Z1518704001_1_T6,	Z1677967537_1_T6,	Z2027507212_1_T1,	Z2094453802_1_T3,	Z2226586903_1_T3,	Z2231547000_1_T6,	Z746232788_1_T1,	Z982106746_1_T2,	Z1326519098_2_T1,	Z1438880238_1_T3,	Z1444370321_2_T2,	Z1455091621_1_T2,	Z1279162038_2_T2,	Z1571125728_2_T2,	Z1739045125_1_T1,	Z1739045125_2_T1,	Z1905037519_1_T1,	Z1945504285_2_T4,	Z2027507212_1_T3,	Z2027507233_1_T1,	Z2227340084_1_T3,	Z2227340170_1_T3,	Z1006544968_1_T2,	Z1516250349_1_T2,	Z1518704001_1_T1,	Z1518704001_1_T5,	Z1571125728_1_T2,	Z1633095325_2_T1,	Z1660303803_1_T2,	Z1677968354_1_T6,	Z1945504285_1_T4,	Z2027110140_1_T1,	Z2227338190_1_T3,	Z2227338905_1_T8,	Z2291073601_1_T2,	Z733867840_1_T1,	Z910746354_1_T2,	Z927972426_1_T1,	Z1171585709_1_T3,	Z1257370428_1_T1,	Z1326398475_1_T1,	Z1326398475_1_T2,	Z1326519098_1_T2,	Z1341889972_1_T4,	Z1374396951_1_T2,	Z1385375749_1_T2,	Z1403811255_1_T1,	Z1518697318_1_T1,	Z1540280152_1_T1,	Z1571125746_2_T2,	Z1633095325_1_T1,	Z1836039437_1_T1,	Z1836071089_1_T8,	Z2027110140_1_T2,	Z2027111240_1_T2,	Z2033475463_1_T3,	Z2077111551_1_T3,	Z2227337895_1_T3,	Z2291073601_1_T1,	Z2292706698_1_T1,	Z232291588_2_T1,	Z1171585709_1_T1,	Z1230181343_1_T5,	Z1257370428_1_T2,	Z1281595786_1_T1,	Z1281595786_2_T1,	Z1325241506_1_T2,	Z1335849729_1_T1,	Z1341889972_1_T1,	Z1385381197_1_T4,	Z1385381625_1_T2,	Z270995876_1_T1,	Z1444370321_2_T1,	Z1518688826_1_T6,	Z1518704001_1_T3,	Z1279162038_2_T1,	Z1560015889_1_T1,	Z1560015889_1_T2]


#create an empty list to store common numbers
common_numbers = []

#loop through each set and check for common numbers
for num in set1:
  if num in set2:
    common_numbers.append(num)

#print the common numbers
print(common_numbers)