表1的A1到Z1格中各有一任意数,当这任意数正好等于2或3或7或15或18或51或100或105时,结果在表2的C1中集合

一个笨办法
=TRIM(IF(COUNTIF(SHEET1!A1:Z1,2),2,"")&" "&IF(COUNTIF(SHEET1!A1:Z1,3),3,"")&" "&IF(COUNTIF(SHEET1!A1:Z1,7),7,"")&" "&IF(COUNTIF(SHEET1!A1:Z1,15),15,"")&" "&IF(COUNTIF(SHEET1!A1:Z1,18),18,"")&" "&IF(COUNTIF(SHEET1!A1:Z1,51),51,"")&" "&IF(COUNTIF(SHEET1!A1:Z1,100),100,"")&" "&IF(COUNTIF(SHEET1!A1:Z1,105),105,"")&" ")