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

[µo°Ý] ¨D§U EXCEL ¦hµ§¶µ¥Ø§ä´M³Ì¥ýµo¥Íªº¤é´Á

[µo°Ý] ¨D§U EXCEL ¦hµ§¶µ¥Ø§ä´M³Ì¥ýµo¥Íªº¤é´Á

½Ð±Ð¦U¦ì¤j¯«
¦p¦ó¼g¥X¤½¦¡§PÂ_³Ì¥ýµo¥Í¤é´Á
A¡BBÄ欰¸ê®Æ
§Æ±æ¦bEÄ榳³Ì¥ýµo¥Í¤é´Áµª®×

Â^¨ú.JPG
2020-5-25 00:36

¥»©«³Ì«á¥Ñ p212 ©ó 2020-5-26 14:15 ½s¿è

¦^´_ 1# wl00261200
E2Àx¦s®æ¿é¤J
=SMALL(OFFSET($B$1,MATCH($D2,$A:$A,)-1,,COUNTIF($A:$A,$D2)),1)
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD