- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 280
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-12-27
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-7-10 23:46 ½s¿è
¦^´_ 8# onegirl0204
chin15¦b9#¤w¸g¦^´_±o«Ü²M·¡¡A¶i¶¥¿z¿ï¬O«Ü¦nªº°ò¥»¾Þ§@
2#trainee ªº§@ªk¥u¬O±N¶i¶¥¿z¿ï°Ê§@¥ÎVBA¨Ó¶i¦æ
¦Ó³Ì®tªº´N¬O§Ú¥Î°}¦C¤½¦¡¨Ó§¹¦¨
¦Ü©ó¤½¦¡ªº§@ªk¡A¨S¦³¬Æ»ò¯S§Oªº
°ß¦³¹ï¦UÓ°ò¥»¨ç¼Æ¤F¸Ñ«á
°w¹ïӮ׻ݨD¥h«ä¦Ò
§An±q§O¤Hªº¤½¦¡¤¤¥h¤F¸ÑÓ¨ç¼Æªº§@¥Î
¾ã²z¥X¬Æ»òª¬ªp¦³þ¨Ç¨ç¼Æ¯à¬£¤W¥Î³õ
µM«á·Q¿ìªk±q¤wª¾ªº±ø¥ó¥h¨D±oÓ¨ç¼Æªº¤Þ¼Æ
¥H¦¹¨Ò=IF(ROW(A1)>COUNTIF($C$2:$C$25,$K$2),"",INDEX(A:A,SMALL(IF($C$2:$C$25=$K$2,ROW($2:$25),""),ROW(A1))))
COUNTIF($C$2:$C$25,$K$2)·N¦bºâ¥X²Å¦X±ø¥óªºÓ¼Æ
¦pªG¦C¸¹¶W¥XӼƴNÅýÀx¦s®æÅã¥Ü¬°ªÅ¦r¦ê
SMALL(IF($C$2:$C$25=$K$2,ROW($2:$25),""),ROW(A1))
³o¬O±qCÄ椤§ä¨ì²Å¦X±ø¥óªº¦ì¸m´N¶Ç¦^¸Ó¦C¸¹§_«h¶Ç¦^ªÅ¦r¦ê¡A³o¤@³s¦êªº¼Æ¦r»PªÅ¦r¦ê¤¤¡A§ä¨ì³Ì¤p¼ÆÈ
©Ò¥H·í¤½¦¡¦V¤U½Æ»s®ÉROW(A1)·|Åܦ¨ROW(A2)¡A´N¶Ç¦^²Ä2¤pªº¼ÆÈ
¦A§Q¥ÎINDEX¥h§ä¨ìAÄ檺²Ä´X¦C§@¬°¶Ç¦^ªºµ²ªG
§A¥i§Q¥Î¤½¦¡½]®Ö¨Ó¬d¬Ý¾ãÓ¤½¦¡ªº¹B§@¶¶§Ç
´N·|¼W¶i§Aªº«ä¦Ò¯à¤O
©Ò¥Hn»¡±qþ¸Ì¾Ç²ß¡A¥»½×¾ÂÀ³¸Ó¬OÓ¤£¿ùªº¦a¤è
¦ý¬O¡A³Ì«áÁÙ¬On¥Ñ¦Û¤vªº«ä¦Ò¨Ó§¹¦¨
|
|