- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ 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 |
|