随笔分类 -  OA (office and VBA)

Excel VBA
摘要：=COUNTIF(Y3:Y212,"=11") =SUMIF(Y3:Y212,"=11",AA3:AA212) =SUMPRODUCT((Y3:Y212="11")*(Z3:Z212=Z223)) 阅读全文

posted @ 2016-06-21 15:43 szllq2000 阅读(146) 评论(0) 推荐(0)

jira attachement directorey,workflow---extention.
摘要：workflow extention. https://confluence.atlassian.com/jirakb/jira-miscellaneous-workflow-extensions-jmwe-removal-from-jira-cloud-815262011.html chattr 阅读全文

posted @ 2016-06-13 10:46 szllq2000 阅读(216) 评论(0) 推荐(0)

词频统计 in office
摘要：ROSTCM6 1. http://www.writewords.org.uk/word_count.asp 2. http://darylkinsman.ca/tools/wordfreq.shtml3. http://www.wordcounter.com/ VBA macro of word 阅读全文

posted @ 2016-01-11 09:49 szllq2000 阅读(551) 评论(0) 推荐(0)