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

[µo°Ý] ½Ð±Ð¦U¦ì¤j¤j³oºØ¶ë¿ï¬O­n¥Î­þºØ¨ç¼Æ??

[µo°Ý] ½Ð±Ð¦U¦ì¤j¤j³oºØ¶ë¿ï¬O­n¥Î­þºØ¨ç¼Æ??

½Ð±Ð¦U¦ì¤j¤j³oºØ¶ë¿ï¬O­n¥Î­þºØ¨ç¼Æ??





¬d¸ß.rar (6.34 KB)

DEAR  SIR
1E5©ñ¦p¤U¨ç¼Æ«á°}¦C«á¤U©Ô§Y¥i .
   1.1 °}¦C = SHIFT + CTRL+ENTER

=IF(ISERROR(INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$B$4B$100=$E$4,ROW(Sheet1!$A$1A$28),""),ROW(A1)))),"",INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$B$1B$28=$E$4,ROW(Sheet1!$A$1A$28),""),ROW($A1))))
ù

TOP

¦^´_ 1# keovin790916

1] »²§UÄæ C4, ¿é¤J¤½¦¡«á. ¤U©Ô¦Ü C13

=B4&COUNTIF(B$4:B4,B4)

2] ªð¦^¸ê®ÆÄæ E5, ¿é¤J¤½¦¡«á, ¦V¥k¤U©Ô¦Ü H Äæ

=IFERROR(OFFSET($A$3,MATCH(E$4&ROW(A1),$C$4:$C$13,),),"")

TOP

·PÁ¤j¤j     Åý§Ú¤S¦h¾Ç¨ì¤F¤@¨Ç

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD