¸óªí¨Ì²Å¦X±ø¥ó¿z¿ï.

leiru

"¿z¿ï"¤u§@ªí¡A­Y¦bB2¿é¤J10305¡A§Æ±æA¡GHÄæ¥h§ì"²Î­p"¤u§@ªí¤º²Å¦XB2ªºA¡GHÄæ¡A¨Ã¦b³Ì«á¤@ÄæÅã¥Ü¦X­p

leiru

¦^´_ 14# p212


  ÁÂÁ±z´£¨Ñªºµª®×¡A§Ú©Ò­nªº´N¬O±z³oÀɮתºµª®×¡C«D±`·PÁ±z
¤£¦n·N«ä¡A¤@ª½³Â·Ð±z¤F¡C:)

p212

¦^´_ 12# leiru
½Ð°Ñ¦Ò¡I

p212

¦^´_ 12# leiru
12#°Ý(¿z¿ï¤u§@ªí¤ºªºL2Àx¦s®æ¬O§_¥i°ÊºAªº¨Ì²Î­p¤u§@ªí¤ºªºBÄæ°µ¤U©Ô¦¡¿ï³æ¡C)¬Ý¨Ó¦³ÂI©_©Ç¡I
±zªº»Ý¨D¬O­n¦b¡u¿z¿ï¡v¤u§@ªí¤ºªº¡uB1Àx¦s®æ¡v«Ø¥ß°ÊºA¿ï³æ¡H

leiru

¦^´_ 11# p212

¤j®v¡G
¤£¦n·N«ä¡A¤@ª½¦V±z½Ð±Ð¡A³o¦¸ªº°ÝÃD¡G
¦]²Î­p¤u§@ªí¤ºªºBÄæ·|¦AÄ~Äò¤@ª½·s¼W¤é´Á¤U¥h¡A¿z¿ï¤u§@ªí¤ºªºL2Àx¦s®æ¬O§_¥i°ÊºAªº¨Ì²Î­p¤u§@ªí¤ºªºBÄæ°µ¤U©Ô¦¡¿ï³æ¡C

p212

¦^´_ 10# leiru
ªþÀɤº¤½¦¡¬°Excel 2007ª©¥H¤W¾A¥Î¡A½Ð°Ñ¦Ò¡I

leiru

¦^´_ 8# p212


    ¤£¦n·N«ä¡A¦A½Ð±Ð¡A¿z¿ï¤u§@ªí¤ºªºL2Àx¦s®æ¬O§_¥i°ÊºAªº¨Ì²Î­p¤u§@ªí¤ºªºBÄæ°µ¤U©Ô¦¡¿ï³æ¡A¦]²Î­p¤u§@ªí¤ºªºBÄæ·|¦AÄ~Äò¤@ª½·s¼W¤é´Á¤U¥h¡C

·PÁ±z¼ö¤ß¦^ÂÐ

leiru

¦^´_ 8# p212


    ÁÂÁ±zªº¦^µª....:)

p212

¦^´_ 7# leiru
²Î­p¤u§@ªíÀx¦s®æL2¿é¤J°}¦C¤½¦¡
for Excel 2007
=IFERROR(INDEX(²Î­p!A$2:A$61,LARGE(IF(--LEFT(²Î­p!$B$2:$B$61,5)=$K2,ROW(²Î­p!$B$2:$B$61)-1,FALSE),1)),"")
for Excel 2003
=IF(ISERROR(LARGE(IF(--LEFT(²Î­p!$B$2:$B$61,5)=$K2,ROW(²Î­p!$B$2:$B$61)-1,FALSE),1)),"",INDEX(²Î­p!A$2:A$61,LARGE(IF(--LEFT(²Î­p!$B$2:$B$61,5)=$K2,ROW(²Î­p!$B$2:$B$61)-1,FALSE),1)))
¦V¤U½Æ»s
½Ð°Ñ¦Ò¡I

leiru

¦A½Ð°Ý¡G
²Î­p¤u§@ªí¤ºªºL2¤ÎL3¦p¦ó¨D¥X­È¡C¡]¨ÌAÄæ¨D¥X¨Óªº¡^