AM3=IF(MOD(ROW(),3)=1,IF(INDEX(4:4,SMALL(IF($D3:$AJ3<>"",COLUMN($D3:$AJ3),99),COLUMN(A1))-1)<>"","左","")&IF(INDEX(4:4,SMALL(IF($D3:$AJ3<>"",COLUMN($D3:$AJ3),99),COLUMN(A1)))<>"","下","")&IF(INDEX(4:4,SMALL(IF($D3:$AJ3<>"",COLUMN($D3:$AJ3),99),COLUMN(A1))+1)<>"","右",""),"")
数组公式。
AT3=INDEX(AM:AM,ROW()*3-5)
统计.rar
(21.83 KB, 下载次数: 17)
|