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

¨­¤ÀÃÒ¦r¸¹«ö­^¤å¦r¥À¤ÀÃþ

¨­¤ÀÃÒ¦r¸¹«ö­^¤å¦r¥À¤ÀÃþ

½Ð°Ý¦U¦ì¥ý¶i¡A¤p§Ì»Ý­n±q¥ªÃä B:D Ä檺¸ê®Æ¤¤¡A«ö¨­¤ÀÃÒ¦r¸¹ªº­^¤å¦r¥À¬°¯Á¤Þ¡A±N¦P¦r¥Àªº¤Hªº¸ê®Æ¦C¦b F:H Äæ¡A¥Î¨º­Ó¨ç¼Æ¤½¦¡¥i¥H¦C¥X¨Ó¡AÁÂÁ¡IÀɮצpªþ¥ó ¨­¤ÀÃÒ¦r¸¹«ö­^¤å¦r¥À¤ÀÃþ.rar (4.2 KB)

¦^´_ 1# shan0948

¨Ì¾ÚF1Àx¦s®æªº¨­¥÷ÃÒ¶}ÀY¡A¦C¥X¦P¶}ÀY¤§¤H­û
   

¤½¦¡¡A¸Ô¤U¹Ï¡G
   
¡iµù¡j2003ª©¡AµLIFERROR¨ç¼Æ

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2017-11-8 11:49 ½s¿è

¥þ³¡{=OFFSET(B$1,RIGHT(SMALL(CODE(LEFT($D$2:$D$99&"a"))/1%+ROW(D$2:D$99),ROW(A1)),2)-1,)

«ü©w¦r¥À{=OFFSET(B$1,SMALL(IF(LEFT($D$2:$D$99)=$F$1,ROW(D$2:D$99),4^8),ROW(A1))-1,)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# joblyc017


    ·PÁ J¤j ªº«ü¾É¤½¦¡¡A¸g¹L´ú¸Õ«á¥i¥H¨Ï¥Î¸ê®Æ¥¿½T¡I

TOP

¦^´_ 3# hcm19522


    ·PÁ H¤j ªº¤½¦¡¨ç¼Æ¡A¸g¨Ï¥Î«á«D±`¹ê¥Î¡A¸ê®ÆÅã¥Ü¥¿½T¡A¦Ó¥B¥i¥H¥þ³¡©Î¿ï¾ÜªºÅã¥Ü¡AÁÂÁ¡I

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD