Board logo

¼ÐÃD: [µo°Ý] ¸ê®Æ¤ñ¹ï°ÝÃD [¥´¦L¥»­¶]

§@ªÌ: aer    ®É¶¡: 2013-10-2 22:03     ¼ÐÃD: ¸ê®Æ¤ñ¹ï°ÝÃD

»¡©ú¡G¨Ò¦p¦bB5ªº®×¦W¡A­n¦Û°Ê»P¨ä«á­±¦Cªº¸ê®Æ§@¤ñ¹ï¡A§YB6:B9¡A¦p¸ê®Æ¬Û¦P¡A«hÅã¥ÜªÅ¦r¦ê¡A¤ñ¹ï¸ê®Æ¤£¦P®É¡A«hÅã¥Ü«Ý¬d¡A½Ð°Ý¦Û°Ê¤ñ¹ïªº¤½¦¡¡A¸Ó¦p¦ó³]©w¡H ¦]¬°¨C­Ó®×¦W«á­±ªº¦C¼Æ±q1¦C¨ì30´X¦C¤£µ¥¡A¦Ó¥Ø«e§Ú¥u·|¥Î¤â°Ê¤ñ¹ïªº¤½¦¡¡A§YB5=IF(ISNA(MATCH(B5,B6:B9,0)),"«Ý¬d","")¡C¦]¸ê®Æ¦³±Nªñ¤W¸U¦C¡A©Ò¥H¡A½Ð¦U¦ì¦Ñ®v¡B«e½ú­ÌÀ°¦£¡A·PÁ¡I



[attach]16228[/attach]
§@ªÌ: ANGELA    ®É¶¡: 2013-10-2 23:37

C5=IF(A5=$A$2,IF(ISNA(MATCH(B5,OFFSET(B6,,,MATCH(A5,A6:A46,)-1,),0)),"«Ý¬d",""),"")
§@ªÌ: aer    ®É¶¡: 2013-10-3 20:26

C5=IF(A5=$A$2,IF(ISNA(MATCH(B5,OFFSET(B6,,,MATCH(A5,A6:A46,)-1,),0)),"«Ý¬d",""),"")
ANGELA µoªí©ó 2013-10-2 23:37


ÁÂÁ Angela ª©¥D¡A¤½¦¡¥i¥H¨Ï¥Î¡C¦ý¬O¡A¦³¤@ÂIÂIªº¤p¿ù»~¡A´N¬O¸ê®Æ¤ñ¹ï¨ì³Ì«á¤@­Ó®×¦W®É¡A¦]¬°«á­±¨S¦³§ä¤£¨ì¥i¥H°t¹ïªº®×¦W¡A¾É­Pµ²ªG³£·|¥X²{"«Ý¬d"¡A¦Ó¹ê»Ú¤W¬O³Ì«á¤@­Ó®×¦W¡A¬O¥i¥H¦b¨ä¤§«áªº¦CùØ­±§ä¨ì¡A¥¿½TÀ³¬O¥X²{ªÅ¦r¦ê¡C½Ð°Ý¦¹³¡¤À­n¦p¦ó­×§ï¡A¤~¯à±o¨ì¥¿½Tªºµª®×©O¡H·Ð½ÐÀ°¦£¡A·PÁ±z¡I
§@ªÌ: aer    ®É¶¡: 2013-10-5 11:21

¦^´_ 2# ANGELA

ÁÂÁ Angela ª©¥D

§Ú§Q¥Î±z©Ò´£¨Ñªº¤½¦¡¡A¸g¹L­×§ï«á¤w¸Ñ¨M°ÝÃD¡A¤½¦¡¦p¤U¡G

C5=IF(A5=$A$2,IF(ISNA(MATCH(B5,OFFSET(B6,,,COUNTA(B:B)-ROW(B5)),0)),"«Ý¬d",""),"")




Åwªï¥úÁ{ ³Â»¶®a±Ú°Q½×ª©ª© (http://forum.twbts.com/)