=IFERROR(INDIRECT("计划!"&INDEX(TEXT(FLOOR(MOD(MOD(SMALL(IF(计划!$G$3:$DU$1000,COLUMN($G:$DU)/1%%+ROW($3:$1000)),ROW(A1))*1.0000001,10000)*1000,{1,1,10000,10000}*1000),{1,1,1,1000})+IFNA({1000,2000,0,#N/A},COLUMN(A1)-1),"!r0c000"),MID("1244443",COLUMN(),1)),),"")
※數組公式,請記得按Ctrl+Shift+Enter
祝順心,南無阿彌陀佛!
|