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

[µo°Ý] ¦p¦ó¥Î¨ç¼Æ¬d§ä1¦C¼Æ¾Ú¬Û¦P­È¹ïÀ³¦ì¸m

[µo°Ý] ¦p¦ó¥Î¨ç¼Æ¬d§ä1¦C¼Æ¾Ú¬Û¦P­È¹ïÀ³¦ì¸m

«e½ú,
¦p­n¬d§ä1¦C¼Æ¾Ú¬Û¦P­È¹ïÀ³¦ì¸m,­n¤U¤°»ò¨ç¼Æ?
Test.zip (3.89 KB)

¦^´_ 1# Qin

B11=LOOKUP(2,1/(($A$11:$A$17=A11)*(ROW($A$11:$A$17)<>ROW())),ROW($A$11:$A$17))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD