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

[µo°Ý] ¦~«×[«~¶µ]¤ñ¸ûªº°ÝÃD,·q½Ð¥ý¶i«üÂI,·P®¦.

[µo°Ý] ¦~«×[«~¶µ]¤ñ¸ûªº°ÝÃD,·q½Ð¥ý¶i«üÂI,·P®¦.

¦~«×[«~¶µ]¤ñ¸û,µ{¦¡¨º¸Ì¿ù¤F,·q½Ð¥ý¶i«üÂI(°ÝÃD¦bªþ¥ó¤º),·P®¦.

111-112¦~¦X­p1.rar (33.23 KB)

§ù¤p¥­

112! H2:J2 ¤U©Ô=IFERROR(VLOOKUP($B2,'111'!$B:$F,COLUMN(C1),),"")
¤u§@ªí3!A1 ¥k©Ô ¤U©Ô=INDEX('111'!B:B,SMALL(IF(COUNTIF('112'!$B:$B,'111'!$B$2:$B$87)=0,ROW($2:$87),99),ROW(A1)))&""
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 1# dou10801
©êºp!¨S»¡©ú²M·¡,[¤u§@ªí3]¦³,¶À¼Ðªº,¬O,[112]¤u§@ªíH.I.JÄæ,¤w¦³¥X²{ªº¶µ¥Ø,¬°¦óÁÙ·|¥X²{,µ{¦¡¨º¸Ì¶·­n½Õ¾ã,·P®¦

111-112¦~¦X­p1.rar (35.79 KB)

§ù¤p¥­

TOP

¦^´_ 3# dou10801

Å޿観°ÝÃD, °õ¦æ¶¶§ÇÀ³¸Ó¦p¤U:
1) arr = 112ªí, ¦r¨å°O¾Ð¥»ªí[«~ºØ]ªº[¦æ¸¹]¦A´î¤@.... dic(arr(i, 2) & "" ) = i - 1
2) ³]¤@­ÓªÅ°}¦Cxrr(1 to ubound(arr)-1, 1 to 4)
3) brr = 111ªí, ³]¤@­ÓªÅ°}¦Cyrr(1 to ubound(brr), 1 to 5)
4) ³v¤@¤ñ¹ï¨ú¥Xbrr[«~ºØ]¹ïÀ³ªº[¦æ¸¹]...r = dic(brr(i, 2) & "" ),  ­Y¦r¨å¦æ¸¹¦s¦b, ¶ñ¤Jxrr, §_«h¶ñ¤Jyrr
5) [«~ºØ]¬O[­^¼Æ²V¦X], ³Ì¦n¥H[¤å¥»«¬ºA]©ñ¤J¦r¨åªºkey, ¦p¤W¥Ü¨Ò

TOP

¦^´_ 4# ­ã´£³¡ªL

·PÁ¡A­ã¤j«üÂI¡A§Ú¾Ç²ß¸Õ¬Ý¬Ý¡C
§ù¤p¥­

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD