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

[µo°Ý] ­û¤u½Ð°²¤é´Áªº¬d¸ß?

[µo°Ý] ­û¤u½Ð°²¤é´Áªº¬d¸ß?

­n¦p¦ó¬d¸ß¨ÃÅã¥Ü­û¤u½Ð°²¤é´Á ?
¦pªþ¥ó

ÁÂÁ¡I

­û¤u½Ð°²ªí.rar (3.11 KB)

b3=IF(COUNTIF(¸ê®Æ®w!B$2:B$14,$A3),LOOKUP(2,1/(¸ê®Æ®w!B$2:B$14=$A3),¸ê®Æ®w!$A$2:$A$14),"")

TOP

ANGELA ªO¤j
¦b1¸¹§dÓTÞ³½Ð°²¡A§dÓTÞ³¦W¦r©ñ¦bBÄæ
¦pªG¦b7¸¹¤]½Ð°²¡A§dÓTÞ³¦W¦r¤]©ñ¦bBÄæ¡A«h¥u·|±a¥X7¸¹
YOYO

TOP

{=IF(COUNTIF(¸ê®Æ®w!$B$2:$H$14,¬d¸ß!$A3)>=COLUMN(A1),INDIRECT("¸ê®Æ®w!R"&SMALL(IF(¸ê®Æ®w!$B$2:$H$14=¬d¸ß!$A3,ROW(A$2:A$14)),COLUMN(A1))& "C1",0),"")}

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-5-26 12:02 ½s¿è

¦^´_ 3# yanto913


    ¤@¯ë¬O¨ÌÃD¨Ò¸ÑÃD,¤]·|¦³º|¬}ªº.
=INDEX(¸ê®Æ®w!$A$2:$A$15,SMALL(IF(¸ê®Æ®w!$B$2:$H$14=$A3,ROW($1:$13),14),COLUMN(A1)))&""
°}¦C¤½¦¡

TOP

¦^´_ 5# ANGELA


    ª©¥D¤j¤j

§Ú¨Ì·Ó±zªº¨ç¼Æ¡A¦bB3Áä¤J«á¡Aµ²ªG¬OªÅ¥Õ

¤£ª¾¬O¦ó­ì¬G?

TOP

¦^´_ 6# jimmuLu

¶À¬Ræ¢ ¶À¥ßæ¢ ªº¸ê®Æ§ï²Î¤@§Y¥i.§ä¤£¨ì·íµM¬OªÅ¥Õ

TOP

¦^´_ 7# ANGELA


    ANGELA ª©¤j:

§ÚÁÙ¬O¦³ºÃ°Ý¡A¯àÀ°¦£¬Ý¬Ý¶Ü?

ÁÂÁÂ

­û¤u½Ð°²ªí--·Ð½Ð­×¥¿.zip (5.49 KB)

TOP

¥»©«³Ì«á¥Ñ fr447446 ©ó 2011-5-26 11:36 ½s¿è

ANGELAª©¥D ¦b5¼Óªº®É­Ô¦³»¡¤F...

°}¦C¤½¦¡

¤½¦¡¿é¤J§¹«á¡A½Ð«ö¤U Ctrl+Shift+Enter..
¨S¨Æ´N¨Ó³}³}

TOP

¦^´_ 9# fr447446


    ÁÂÁÂfr447446 ¥S«ü±Ð:

¸g±z«üÂI¦A¬O¹L¤w¸g¥i¥H¤F¡A¤£¹L¦pªG¤é´Á¼W¥[¨ì31¤é¡A¤H­û¼W¥[¨ì12¤H

µy·L­×¥¿¨ç¼Æ¡AªÅ¥Õªº¦a¤è§¡¬°14¡A½Ð°Ý¨º¬O¬°¦ó?

·Ð½Ð½ç±Ð:handshake

­û¤u½Ð°²ªí_fr447446.zip (7.45 KB)

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD