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

[µo°Ý] §ì¨ú¹ïÀ³­q³æ©Ò¦³§ó´«­ì¦]¦Ü³æ¤@Àx¦s®æ

[µo°Ý] §ì¨ú¹ïÀ³­q³æ©Ò¦³§ó´«­ì¦]¦Ü³æ¤@Àx¦s®æ


»Ý¨D:
CÄæ¨Ï¥Î¤½¦¡¡A·íAÄæ­q³æ»P¡u¸ê®Æ¨Ó·½¡vAÄæ­q³æ¬Û²Å¡A¨ÃBÄ欰"§ó´«"®É¡A
±N©Ò¦³¡u¸ê®Æ¨Ó·½¡vAÄæ¬Û²Å­q³æ¥BBÄ欰"§ó´«"ªºCÄæ­ì¦]¡A§ì¨ú¦ÜCÄæ¹ïÀ³Àx¦s®æ¡A¨Ã¥HÂ_¦æ¤è¦¡§e²{

¨Ò¦p:
1. A2­q³æ¬°"12345"¡A¡u¸ê®Æ¨Ó·½¡vAÄæ­q³æ¬Û²Å¥BBÄ欰"§ó´«"¡A¬°A2¡BA6¡BA11¡BA12
¬G±NC2¡BC6¡BC11¡BC12ªº­ì¦]¡A±a¤JC2¨Ã¥HÂ_¦æ¤è¦¡Åã¥Ü

2.¡u¸ê®Æ¨Ó·½¡vA8 ÁöµM­q³æ¤]¬Û²Å¡A¦ýª¬ºA«D"§ó´«"¡A¬GµL»Ý§ì¨ú¸Ó¦C­ì¦]

3. A5­q³æ¬°"43155"¡A¡u¸ê®Æ¨Ó·½¡vAÄæ­q³æ¬Û²Å¥BBÄ欰"§ó´«"¡A¬°A4¡BA14
¬G±NC4¡BC14'ªº­ì¦]¡A±a¤JC5¨Ã¥HÂ_¦æ¤è¦¡Åã¥Ü

¥H¤W¨D¸Ñ~~~~~«D±`·PÁ£¬


´ú¸Õ.rar (8.35 KB)
*¦v¤k¤@ªTµL»~*

(»²§U)¸ê®Æ¨Ó·½!D2:D14=IF(B2="§ó´«",IFERROR(LOOKUP(1,0/(A2=A$1:A1)/(B$1:B1="§ó´«"),D$1:D1),"")&" , "&C2,"")

§ó´«!C2:C5=IF(B2="§ó´«",MID(LOOKUP(1,0/(A2=¸ê®Æ¨Ó·½!A$2:A$14),¸ê®Æ¨Ó·½!D$2:D$14),4,99),"")
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522


   h¤j~~~~«D±`·PÁ¡A¥¿¬O¤p©f©Ò»Ý¡A¦A¦¸·Pú§A³á~~~~~~
*¦v¤k¤@ªTµL»~*

TOP

        ÀR«ä¦Û¦b : ÀR§¤±`®¦¤v¹L¡B¶¢½Í²ö½×¤H«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD