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

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

人气：113 ℃　时间：2020-03-08 17:05:21

解答

一个笨办法
=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,"")&" ")