財務人處理憑證的Excel公式!
=MOD(ROW(A1),2)=1
=IF(MOD(ROW(A1),2)=1,內容,'')
=ROUND(ROW(A1)/2,0)
=INDEX(彙總原表!A:A,ROUND(ROW(A1)/2,0)+2)
=IF(MOD(ROW(A1),2)=1,INDEX(彙總原表!A:A,ROUND(ROW(A1)/2,0)+2),'')
=IF(MOD(ROW(A1),2)=1,INDEX(彙總原表!G:G,ROUND(ROW(A1)/2,0)+2),'')
=IF(MOD(ROW(A1),2)=1,'',INDEX(彙總原表!G:G,ROUND(ROW(A1)/2,0)+2))
=IF(MOD(ROW(A1),2)=1,INDEX(彙總原表!E:E,ROUND(ROW(A1)/2,0)+2),INDEX(彙總原表!F:F,ROUND(ROW(A1)/2,0)+2))
·END·