Excel
iteye_21322
这个作者很懒,什么都没留下…
展开
-
Excel Percentile
Excel: PERCENTILE.INC(A1:A5,0.2) = 1.6 Steps: 1. a = 0, 2, 3, 4, 5 2. percent = 0.2 3. n = 5 4. k = TRUNC(percent * (n – 1) + 1) = TRUNC(0.2 * 4 + 1) = TRUNC (1.8)...2014-02-20 13:03:19 · 241 阅读 · 0 评论 -
Making sense of dollar signs in Excel
http://blogs.office.com/2011/08/17/making-sense-of-dollar-signs-in-excel/ Dollar signs indicating absolute references You probably know that a formula can refer to cells. That’s one reason Ex...原创 2014-03-27 10:13:39 · 114 阅读 · 0 评论 -
Excel Combo Box - Add Option Values
1. Add a Combo Box from Form Controls 2. Format the Combo Box 3. Done2014-09-12 15:05:20 · 127 阅读 · 0 评论 -
MYSQL Connector: 32-bit or 64 bit?
Excel是32位,不管操作系统是32位还是64位,MYSQL的Connector也要用32位的。 http://stackoverflow.com/questions/9818365/vba-mysql-issue-using-odbc-connector MYSQL Connector 5.3.4下载 http://dev.mysql.com/downloads/conne...原创 2014-10-13 16:19:13 · 439 阅读 · 0 评论