ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¤é´ÁµLªk¨Ï¥Îmax¨ç¼Æ§ä¥X³Ì¤j/³Ì¤p­È?

[µo°Ý] ¤é´ÁµLªk¨Ï¥Îmax¨ç¼Æ§ä¥X³Ì¤j/³Ì¤p­È?

excelªº¤é´Á¥»½è¤WÀ³¸Ó´N¬O¤@²Õ¼Æ¦r
©Ò¥Hmax/min¨ç¼ÆÀ³¸Ó¥i¥Hª½±µ¨Ï¥Î
¥i¬O³o­ÓÀɮ׫o¤£¦æ...
´Nºâ§â¤½¦¡Âন­È¤]¤@¼Ë
©³¦â¬õ¦â¬Omax¤½¦¡ªº¦a¤è
³Â·Ð¦U¦ì¤F~
TEST.zip (15.98 KB)

­ì¸ê®Æ¨Ã¤£¬O¤é´Á®æ¦¡,¥i¦b¥ô¤@Àx¦s®æ¤º¿é¤J1¡A«öCTRL+C ¡A¿ï¤é´Á½d³ò¡A¿ï¾Ü©Ê¶K¤W¡A¿ï­¼¡C
±N®æ¦¡§ï¦¨¤é´Á®æ¦¡¡A´N¥i­pºâ¤F¡C

TOP

¦^´_ 1# lalalada
ªþÀÉ ªº C31:H36 ¬O ¤å¦r®æ¦¡ ¶·­×§ï¬° ¤é´Á®æ¦¡
¤u§@ªíªº­pºâ¤è¦¡ ¿ï¶µ ¬O¤â°Ê  ­n§ï¦¨¦Û°Ê
2003 ¤u¨ã->¿ï¶µ->­pºâ->­pºâ¤è¦¡

TOP

¦^´_ 3# GBKEE
¦^´_ 2# ANGELA

§Ñ¤F»¡©ú ³o­Ó§Ú¤]¸Õ¹L....
¥¼©R¦W.JPG
2012-8-16 13:17


¦ý¬O¦p¹Ï©Ò¥Ü
·|Åܦ¨1900/1/0
³o¦n¹³¬Û·í©ó¤é´Á¸Ìªº"0"

¤£¦n·N«ä­nÄ~Äò³Â·Ð¦U¦ì@@

TOP

¦^´_ 4# lalalada
¹Ï¤ù¤W: ÁöµM§ï¬°¤é´Á®æ¦¡ ¤´¬O¤å¦r ¶·¦b¨C¤@Àx¦s®æ¤W «öF2, «á«ö Enter  (°µ¿é¤Jªº°Ê§@) ,¤~·|¬O¼Æ¦r.

TOP

¦^´_ 5# GBKEE

®¦ ¦¹ªk¥i¦æ!
¥i¬O¤£¤ÓÀ´
"¤å¦r"©Î"¼Æ­È"«üªº¬O«¬§O¶Ü?
¨ºÂI¥kÁä¿ïÀx¦s®æ®æ¦¡§ïªº¬O¤°»ò?
§Ú¥Î¿ý»s¬ö¿ý«öF2+enter³o­Ó°Ê§@
±o¨ì ActiveCell.FormulaR1C1 = "3/12/2012"
....·Pı¤£¥X¸ò­ì¥»¦³¤°»ò¤£¦P ¦ý¬O¦³®Ä@@"
§ï¦¨ ActiveCell.FormulaR1C1 = ActiveCell.Value
¤]¨ÌµM¦³®Ä
²ö¦W¨ä§®¤¤..."
¬O§_¦³§ó²³æªº¤èªk¥i¥H§ïµ½³o­Ó°ÝÃD©O?(VBA?)

TOP

¦^´_ 6# lalalada
Àx¦s®æªº®æ¦¡ ³]¬°¤å¦r,¤º®e³Qµø¬°¤å¦r
Áö¸g­×§ï¬°¼Æ¦r®æ¦¡, ÁÙ¬Oµø¬°¤å¦r  ©Ò¥H¦³»Ý¦A¦¸ªº¿é¤J ¤~·|µø¬°¼Æ¦r
¦]³o¬O¤@¯ë°Ï  ©Ò¥H¥Î ¤@¯ë°Ïªº­×¥¿
  1. Sub Ex()
  2.     [C31:H36].Value = [C31:H36].Value
  3.     '[C31:H36].Select
  4.     'Selection.Value = Selection.Value
  5. End Sub
½Æ»s¥N½X

TOP

¦^´_ 6# lalalada
I31°}¦C¤½¦¡
=MAX(--C31:H36)
¤å¦r«¬ºA»P¤é´Á(¼Æ­È)«¬ºAªºÂà´«
¦pªG³æÄæ¥i§Q¥Î¤å¦r­åªR¾ãÄæ§ó§ï
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# Hsieh
¦^´_ 7# GBKEE

¤F¸Ñ¤F!
·PÁ¨â¦ìªº¸Ñ»¡:)

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD