儲存格公式改以VBA執行 - 工作
By Harry
at 2014-07-22T00:00
at 2014-07-22T00:00
Table of Contents
將下列的儲存格公式改以VBA執行感謝大大在此Sheets(“SA”)的前VBA程式(恐被違規刪題,未能指名),同一工作表續增VBA程式。藍粗體為單格式,其餘為區域公式(紅色的區域起始點不同於其他)。1.J1=IF(L1="",COUNTA(AN2:AN100),COUNT(AK2:AK456))2.K1=IF(L1="","L1空白",IF(COUNTIF(C:C,L1)=1,L1,CHOOSE(MIN(2,COUNTIF(C:C,"*"&L1&"*"))+1,"非CP",VLOOKUP("*"&L1&"*",C:C,1,),"加字")))3.L2=IF($L1="","↑",IF(COUNTIF($C:$C,$L1)=1,VLOOKUP($L1,$C:$
Tags:
工作
All Comments
By Tracy
at 2014-07-26T20:48
at 2014-07-26T20:48
By Suhail Hany
at 2014-07-24T20:31
at 2014-07-24T20:31
Related Posts
高中畢業想讀大學但是有小孩要扶養
By Dinah
at 2014-07-21T00:00
at 2014-07-21T00:00
鹹豬手別來拒絕職場性騷擾問題答案
By Kama
at 2014-07-21T00:00
at 2014-07-21T00:00
請問目前哪些證照對工作最有幫助
By Ivy
at 2014-07-21T00:00
at 2014-07-21T00:00
剛出社會找工作但太緊張了…
By Susan
at 2014-07-21T00:00
at 2014-07-21T00:00
有關到酒店上班的問題?
By Carolina Franco
at 2014-07-21T00:00
at 2014-07-21T00:00