公式
在单元格C2中输入数组公式:
=IF(ISNUMBER(MATCH(COLUMNS($C:C),IF(INDEX(MOD(INT((Arry2-1)/2^(TRANSPOSE(Arry1)-1))...此时单元格C2中的公式变为:
=IF(ISNUMBER(MATCH(1,IF({1,0,1,0,1,1,0,0,0},TRANSPOSE(Arr1)),0)),”X”,””)
转换为:
=IF(ISNUMBER...(MATCH(1,IF({1,0,1,0,1,1,0,0,0},{1,2,3,4,5,6,7,8,9}),0)),”X”,””)
转换为:
=IF(ISNUMBER(MATCH(1,{1,FALSE,3...在单元格D2中:
=IF(ISNUMBER(MATCH(2,{1,FALSE,3,FALSE,5,6,FALSE,FALSE,FALSE},0)),”X”,””)
得到:
=IF(ISNUMBER(#N...在单元格E2中:
=IF(ISNUMBER(MATCH(3,{1,FALSE,3,FALSE,5,6,FALSE,FALSE,FALSE},0)),”X”,””)
得到:
=IF(ISNUMBER(3)