¦p¦ó§ì¨ú¥t¤@Sheet¸Ì¦UÄæ¦ìªº¸ê®Æ
- ©«¤l
- 14
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 21
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-7-7
- ³Ì«áµn¿ý
- 2012-8-13
|
¦p¦ó§ì¨ú¥t¤@Sheet¸Ì¦UÄæ¦ìªº¸ê®Æ
Hsieh¶W¯Åª©¥D~±z¦n
·PÁ¤§«e¬°¤p§Ì¸Ñ¨M¤@¨ÇEXECLªº°ÝÃD~
²{¦b¤p§Ì¤S¦³¤@ÓÃøÃD~´N¬On§ì¨úSheetªº¸ê®Æ
¨Ò¦p:
¸ê®Æ«Ç¨C¤Ñ¦bÅܰʪº~ÁÙ¦³¨C¤Ñªº¸ê®Æ¦³¤Tµ§~·íìSheet¬°¾î¦¡¸ê®Æn¥t¤@SheetÂনª½¦¡
¦Ó¥BÂনª½¦¡«á~¦]¬°¾Ç¥Í¦h¸ê®Æ¦h~·Q§Q¥ÎÀx¦s®æ¥k¤U¨¤©ì©Ô¤è¦¡½Æ»s~½T¸ê®Æ¹ï¤£¤W(ª½¦¡¸ê®Æ¥u¦³¤@Äæ¾î¦¡¦³¤Tµ§,§ì¨ì¿ù»~ªº¸ê®Æ)
ªþ¤W²²¤ÀÉ®×~·Q½Ð§AÀ°¨¾~
ÁÂÁÂ~·P®¦~~~~~~ |
|
|
|
|
|
|
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
=INDIRECT("°ò¥»È!r"&MATCH($A$3,°ò¥»È!$A$1:$A$32,)&"c"&MATCH(M$1,°ò¥»È!$A$1:$BR$1,)+ROW(A1)-1,0) |
|
|
|
|
|
|
- ©«¤l
- 14
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 21
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-7-7
- ³Ì«áµn¿ý
- 2012-8-13
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-8-10 20:52 ½s¿è
ANGELA §A¦n~ÁÂÁ§Aªº¸Ñµª~
¥i¬O·íSheet°ò¥»Èªº³Ì«e±ÁÙ¦³¤@¨Ç³Æ¥Î»¡©úÄæ¦ì(¬ù¦³¦h¤F8ÓÄæ¦ì)
¾ãÓSheet¤ÀªR°Ï~§ì¨úÈ´N¿ù¶Ã¤F~
§Ú¤w¸gªá¤F¤@¾ã¤Ñ~·Qקï°Ñ¼Æ~ÁÙ¬OµLªk³B²z~(¥i¯à§Ú«Ü¹ï³o¨Ç«ü¥O¤£²M·¡)
ÁÙ¦³µ{¦¡=INDIRECT("°ò¥»È!r"&MATCH($A$3,°ò¥»È!$A$1:$A$32,)&"c"&MATCH(M$1,°ò¥»È!$A$1:$BR$1,)+ROW(A1)-1,0)
¨ºÓrÁÙ¦³&¥H¤Î"c"¦A¥[¤W"ROW(A1)-1"ªº§@¥Î¬O¬Æ»ò~§Ú¤£À´~·Q¦A½Ð±Ð§A~
·P®¦~~~~ |
|
|
|
|
|
|
- ©«¤l
- 14
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 21
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-7-7
- ³Ì«áµn¿ý
- 2012-8-13
|
|
|
|
|
|
|
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 277
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-12-23
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-8-10 21:05 ½s¿è
¦^´_ 4# wghost
M1=INDIRECT("°ò¥»È!r"&MATCH(LOOKUP("ùÕ",$A$3:$A3),°ò¥»È!$I:$I,0)&"c"&MATCH(M$1,°ò¥»È!$1:$1,)+ROW($A1)-1,0)
MATCH(LOOKUP("ùÕ",$A$3:$A3),°ò¥»È!$I:$I,0)§ä¥X¾Ç¥Í©Ò¦b¦C¸¹
MATCH(M$1,°ò¥»È!$1:$1,)§ä¨ì¸Ó¤é´ÁÄæ¦ì
ROW($A1)-1¦V¥k¦ì²¾¶q |
|
¾Ç®üµL²P_¤£®¢¤U°Ý
|
|
|
|
|
- ©«¤l
- 14
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 21
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-7-7
- ³Ì«áµn¿ý
- 2012-8-13
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-8-11 15:19 ½s¿è
Hsieh¶W¯Åª©¥D¤jô~±z¦n
ÁÂÁ±zªº¸Ñµª~
¦ý«Ü©_©Ç£°~
§Ú±N±zµ¹ªºµ{¦¡½Æ»s¦b"±ý³B²zÀɮ׸Ì"¬OOKªº~
¦ý§Ú±N¥¦½Æ»s¦b¥¿¦¡ªºÀɮתí®æ¸Ì~«o¬O¥X²{#N/A~
«á¨Ó¹Á¸Õ¤F«Ü¤[~ÁÙ¬OµLªk¦pÄ@~
ÁÙ¦³MATCH(LOOKUP("ùÕ",$A$3:$A3)ªº"ùÕ"¬O¬Æ»ò~
§Ú¯Á©Ê¤£¥Î½Æ»sªº~§âµ{¦¡¤@¦r¤@¦rºV¶i¥h~«o¥X²{µ{¦¡¿ù»~~¿ù»~ÂI¦b"ùÕ"ªº¦r¤W±~
¨þ¨þ~§Ú¯u¬O¾Ç¤£·|~²Â£°
¦A¦¸½Ð±Ð~ |
|
|
|
|
|
|
- ©«¤l
- 23
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 31
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- 20xx
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-8-11
- ³Ì«áµn¿ý
- 2012-8-28
|
¦^´_ 5# Hsieh
M1=INDIRECT("°ò¥»È!r"&MATCH(LOOKUP("ùÕ",$A$3:$A3),°ò¥»È!$I:$I,0)&"c"&MATCH(M$1,°ò¥»È!$1:$1,)+ROW($A1)-1,0)
³o¼Ëªº¤½¦¡½Æ»s¨ì²Ä2ӾǥͥH«á´N¥X¿ù¤F
M1=INDIRECT("°ò¥»È!r"&MATCH(LOOKUP(2,1/($A$3:$A3<>""),$A$3:$A3),°ò¥»È!$I:$I,0)&"c"&MATCH(M$1,°ò¥»È!$1:$1,)+MOD(ROW()-14,11),0)
³o¼Ë¨CӾǥͳ£¬O10¦C¸ê®Æ¡A¤¤¶¡ªÅ¤@¦æ¤~¹ïÀ³ªº¤W |
|
|
|
|
|
|
- ©«¤l
- 14
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 21
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-7-7
- ³Ì«áµn¿ý
- 2012-8-13
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-8-11 22:45 ½s¿è
¨þ¨þ~
ªGµM¦pHsieh¶W¯Åª©¥D¤jô±z©Ò»¡ªº~
½T¹ê§Úªº¤ÀªR°ÏAÄæ¦ì¬O¥H®y¸¹½s¸¹¬°¶}ÀY~§Ú¤w¸g§â¼Æ¦r®y¸¹½Õ¶}¤F~
¨þ¨þ~©~µMOK¤F~¦ý¤]¶·§ï¦¨LOOKUP(2,1/($A$3:$A3<>""),$A$3:$A3)
¤]ÁÂÁ¦U¦ì¤j¤j(white945)¬ÛÃö¸ê°Tªº´£¨Ñ~
¸U¤À·P®¦~~~~~~~~~~ |
|
|
|
|
|
|
- ©«¤l
- 14
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 21
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-7-7
- ³Ì«áµn¿ý
- 2012-8-13
|
Hsieh¶W¯Åª©¥D~±z¦n~
£°«Ü©_©Ç£°
¦b¥¿¦¡ªºÀɮתí®æ¸Ì~·í¤Ñ¤ÀªRªíSheet"³Ì°ªÈ"Äæ¦ì~«ç»ò¬O¥X²{¸Ó"¾Ç¥Íªº¦W¦r"(·í¤Ñªº¨ä¥Lȳ£¥¿±`)
§ó©_©Çªº¨Æ~§Ú¹Á¸Õ½Õ¾ã¹q¸£¤é´Á¬°¦¸¤@¤é~«o´«¦¨¦¸¤@¤é"³Ì°ªÈ"Äæ¦ì¬O¸Ó"¾Ç¥Íªº¦W¦r"~¦Ó«e¤@¤éªº"³Ì°ªÈ"¤w¦^´_¥¿½TªºÈ¤F~????
©Ç£°~¨þ¨þ~ |
|
|
|
|
|
|