- ©«¤l
- 472
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 485
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- MS Office
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »´ä
- µù¥U®É¶¡
- 2010-7-4
- ³Ì«áµn¿ý
- 2014-12-28
|
½Ð°Ý¦p¦ó¥ÎVBAºâ¥Xtick ®É¶¡ ¶}½L»ù ³Ì°ª»ù ³Ì§C»ù ¦¬½L»ù ¦¨¥æ¶q
ÁÂÁÂ
jerrystock µoªí©ó 2012-9-18 20:41
²³æ¥Î¤½¦¡¤£´N¥i¥H¶Ü
¦h¤Ö¦æ 24216 =COUNT(A:A)
¶}½L»ù 7735 =B2
³Ì°ª»ù 7769 =MAX(B:B)
³Ì§C»ù 7713 =MIN(B:B)
¦¬½L»ù 7749 =INDEX(B:B,MATCH(9.99999999999999E+307,B:B))
¦¨¥æ¶q 33413 =SUM(C:C)- Sub test()
- Dim count, ¶}½L»ù, ³Ì°ª»ù, ³Ì§C»ù, ¦¬½L»ù, ¦¨¥æ¶q
- count = Application.WorksheetFunction.count(Range("A:A"))
- ¶}½L»ù = [B2]
- ³Ì°ª»ù = Application.WorksheetFunction.Max(Range("B:B"))
- ³Ì§C»ù = Application.WorksheetFunction.Min(Range("B:B"))
- ¦¬½L»ù = [B2].End(xlDown)
- ¦¨¥æ¶q = Application.WorksheetFunction.Sum(Range("C:C"))
- End Sub
½Æ»s¥N½X |
|