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

[µo°Ý] ­ç°£­«½Æ¦r

[µo°Ý] ­ç°£­«½Æ¦r

¦p¦ó¦bAÄæ¤U¤½¦¡,·í°»°¼¨ìC©MDÄ椤ªº¦r¬O»PAÄæ­«½Æ®É,«h¤£³sµ²¡H
AÄæ¬O±M¥Î¨Ó³sµ²BCDÄæ
BÄæ¬O¥DÄæ¦ì,¤]´N¬O³sµ²®É¥²©w­n¦³ªº
·í°»°¼¨ìC©MDÄ椤ªº¦r¬O»PAÄæ­«½Æ®É,«h¤£³sµ²
EÄæ¬O§Ú·Q­nªºµ²ªG

¤£­«½Æªº³sµ².rar (7.42 KB)

=B2&IF(COUNT(FIND(C2,B2&D2))-(C2=D2)+(C2=""),,"➨"&C2)&IF(COUNT(FIND(D2,B2&C2)),,"➨"&D2)

TOP

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

½Ð°Ý¤j¤j,
²Ä11¦C³oºØ±¡§Î­n«ç»ò§ï¼g¡H   ¤£­«½Æªº³sµ²2.rar (7.98 KB)
®ðÀ£¬û CDQ2B32-5DRS➨CDQ2B32-5DRS

TOP

¦^´_ 3# PJChen


=B2&IF(COUNT(FIND(C2,B2))+COUNT(FIND(C2,D2))-(C2=D2),,"➨"&C2)&IF(COUNT(FIND(D2,B2&C2)),,"➨"&D2)

TOP

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

·PÁÂ...¦h¾Ç¤F¤@ºØ¤½¦¡¥Îªk

TOP

        ÀR«ä¦Û¦b : ¦a¤WºØ¤Fµæ¡A´N¤£©öªø¯ó¡F¤ß¤¤¦³µ½¡A´N¤£©ö¥Í´c¡C
ªð¦^¦Cªí ¤W¤@¥DÃD