FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;…;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE}
传递给MATCH函数...0,1,0,0,0,0,0,0,0;
1,1,0,0,0,0,0,0,0;
……
1,0,1,1,1,1,1,1,1;
0,1,1,1,1,1,1,1,1;
1,1,1,1,1,1,1,1,1},54,)
由于INDEX函数忽略了列参数...此时单元格C2中的公式变为:
=IF(ISNUMBER(MATCH(1,IF({1,0,1,0,1,1,0,0,0},TRANSPOSE(Arr1)),0)),”X”,””)
转换为:
=IF(ISNUMBER...在单元格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)