K6{=IFERROR(ADDRESS(LEFT(SMALL(IF(ISERR(-B$3:H$8),ROW($3:$8)/1%+MOD(COLUMN(A:G)+MOD(ROW(A2),2)*4,8)+1),INT(ROW(A2)/2))),RIGHT(SMALL(IF(ISERR(-B$3:H$8),ROW($3:$8)/1%+MOD(COLUMN(A:G)+MOD(ROW(A2),2)*4,8)+1),INT(ROW(A2)/2))),4),"")
L6=IF(K6="","",INDIRECT(K6))
留言
張貼留言