¦p¦ó§ì¨ú¥t¤@Sheet¸Ì¦UÄæ¦ìªº¸ê®Æ
- ©«¤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 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
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 258
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-28
|
¥»©«³Ì«á¥Ñ 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
|
|
|
|
|
|
|
- ©«¤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
- 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) |
|
|
|
|
|
|