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

ÅçÃÒ¤U©Ô¦¡¿ï³æ¤£­«½Æ

ÅçÃÒ¤U©Ô¦¡¿ï³æ¤£­«½Æ

¦U¦ì¤j¤j¡G
ª¦¤å«á¡A§Ú¤´µLªk§ä¨ìµª®×¡A½Ð¤j¤j­Ì¨ó§U¡I
»s§@¤U©Ô¦¡¿ï³æ¡A¦ý­n±Æ°£­«½Æ¿ï¶µ¡A¦]¬°­ì©l¸ê®Æ¨C¤é³£·|¤@ª½²Ö¥[¤U¥h¡A
¤]·|¤@ª½§ïÅÜ/·s¼W¤£¦P¿ï¶µ¡A¦]¦¹µLªk¥ý¥H¶i¶¥¿z¿ï³B²z¹L¡A
¬°¤F¤é«á¨Ï¥Î«K§Q¡A©Ò¥H¤]¤£·Q¨C¦¸³B²z®É­n¥ý¶i¦æ¥[¤u§@·~¡A½Ð°Ý¦³¤°»ò¿ìªk¥i¥H¸Ñ¨M¶Ü¡H

book1.rar (29.58 KB)

·s¤H¤@ªT

¥»©«³Ì«á¥Ñ p212 ©ó 2014-6-25 17:05 ½s¿è

¦^´_ 1# eric093
¥H¼W¥[»²§UÄæ¤è¦¡¥ý¿z¿ï¥XAÄ椤¡u°ß¤@ªÌ¡v¡A¤§«á¦A¥H¸Ó»²§UÄæ¥Î©óÅçÃÒ¸ê®Æ¥\¯à²£¥Í¤U©Ô¦¡¤£­«½Æ¤§¿ï³æ¡C
1¡B©w¸q¦WºÙ¡u©m¦W¡v¡A¡u°Ñ·Ó¨ì¡v¿é¤J
=OFFSET(Sheet1!$A$2,,,COUNTA(Sheet1!$A:$A)-1)
2¡B¦Û¦æ¿ï©w¬YÄæ»s³y»²§UÄæ¡A¥HGÄ欰¨Ò¡A©óG1Àx¦s®æ¿é¤J¡uList¡v¡A¨Ã©óÀx¦s®æG2¿é¤J°}¦C¤½¦¡
=IFERROR(INDEX(©m¦W,MATCH(0,COUNTIF($G$1:G1,©m¦W),0)),"")
¦V¤U½Æ»s¤½¦¡
3¡B¦A©óÅçÃÒ¸ê®Æ¤§¡u¨Ó·½¡v¿é¤J
=List
¥H¤W©å¨£¡A½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# p212

http://jingyan.baidu.com/article/046a7b3ef9635ff9c27fa9e8.html
³oùئ³¸Ô²Ó»¡©ú.

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD