EXCEL用巨集寫出陣列公式 - 工作
By Kumar
at 2015-01-18T00:00
at 2015-01-18T00:00
Table of Contents
1.{=IF(R3="","",INDEX($B$3:$B$30002,SMALL(IF($Q$3:$Q$30002=1,ROW($Q$3:$Q$30002)),COUNTIF($R$3:$R3,R3))-2))}上述寫在單元格內,按下SHIFT+CTRL+ENTER後變成陣列公式,可以執行但每次開檔就會重萛,很麻煩所以想用巨集,我天真的寫成cells(1,1)="=IF(R3="","",INDEX($B$3:$B$30002,SMALL(IF($Q$3:$Q$30002=1,ROW($Q$3:$Q$30002)),COUNTIF($R$3:$R3,R3))-2))"但不能使用,請有問人可以教一下,在巨集中,如何去定義使用嗎?2.,如果要選取別的分頁單位格範圍,要怎麼寫例如在同一個分頁,我要選取一��
Tags:
工作
All Comments
By Connor
at 2015-01-19T03:54
at 2015-01-19T03:54
Related Posts
英文自傳糾正
By Edward Lewis
at 2015-01-18T00:00
at 2015-01-18T00:00
想請問有關於台中金錢豹的問題!15點!
By William
at 2015-01-18T00:00
at 2015-01-18T00:00
老公吸毒,我要離婚
By Selena
at 2015-01-18T00:00
at 2015-01-18T00:00
雖然是自己親姐姐,但還是很煩......
By Ingrid
at 2015-01-18T00:00
at 2015-01-18T00:00
有人先去菲律賓唸英文再去澳洲打工度假嗎?
By Kelly
at 2015-01-18T00:00
at 2015-01-18T00:00