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

º¡¨¬®É¶¡½d³ò¤º¥B«ü©w±ø¥óªº¸ê®Æ±Æ§Ç~¯x°}¤½¦¡­×¥¿

º¡¨¬®É¶¡½d³ò¤º¥B«ü©w±ø¥óªº¸ê®Æ±Æ§Ç~¯x°}¤½¦¡­×¥¿

excel ¸ê®Æ®w¤¤
AÄæ¦ì¬O®É¶¡
BÄæ¦ì¬O«~¦W
CÄæ¦ì¬O¥ó¼Æ
DÄæ¦ì¬O¼t°Ó

¤µ¤Ñ©óE1, F1, G1, H1, I1¥|®æ¤l
¤À§O¶ñ¤J°_©l®É¶¡, µ²§ô®É¶¡, «ü©w«~¦W, «ü©w¥ó¼Æ, «ü©w¼t°Ó

§Ú­ì¥»ªººc·Q:
¦bJ1¶ñ¤J¤½¦¡Åý¨ä¦^¶Ç²Å¦X¥H¤W«ü©w¶µ¥Ø¥B®É¶¡³Ì¤pªº¦C
={MOD(SMALL(ABS($E$1*10000-IFERROR(FIND(G1,B:B)*FIND(H1,C:C)*FIND(I1,D:D)*A:A,100000)*10000)*10000+ROW(A:A),1),1000)}

J2¤]¬O¦P¼Ë¤½¦¡, ¥u­n§ó§ïSMALLªºRANK¬°2, J3¬°3, J4¬°4.....¥H¦¹Ãþ±À

³o¼Ë§Ú´N¥i¥H±qJÄæ±oª¾²Å¦X±ø¥óªº¸ê®Æ¦b­þ¤@¦C, ¨Ã¥Ñ«ü©w®É¶¡¤p¨ì¤j±Æ¦C¤F

¥i¬O±o¨ìªºµ²ªG«o¬O¦b®É¶¡½d³ò¥~ªº¸ê®Æ¤]·|¶i¨Ó(¦n¹³¬Oµ´¹ï­È¨ç¼ÆABSªºÃö«Y....) ½Ð°Ý°ª¤âª¾¹D¦p¦ó­×§ï¤½¦¡¶Ü?

¥t¥~¦³³\¦h«~¦Wªº¥ó¼Æ(CÄæ)¬O¶ñ¤J¤å¦r©ÎªÌ¬°0ªº, ³o¨Çµ²ªG§Ú¤]¤£·Q¦C¤J°}¦C¤ñ¹ï, ¸Ó«ç»ò¥[¤J§P§O¦¡©O? ·P¿E

¦^´_ 1# i723

=MOD(SMALL(IF((A$2:A$999>=E$1)*(A$2:A$999<=F$1)*(B$2:B$999=G$1)*(C$2:C$999=H$1)*(D$2:D$999=I$1),ROUND(A$2:A$999*10^9,-5)+ROW($2:$999)),ROW(A1)),10^5)
°}¦C¤½¦¡
¥i¤U©Ô

©Î±NA¡BB¡BC¡BD©w¸q¦WºÙ
=MOD(SMALL(IF((®É¶¡>=E$1)*(®É¶¡<=F$1)*(«~¦W=G$1)*(¥ó¼Æ=H$1)*(¼t°Ó=I$1),ROUND(®É¶¡*10^9,-5)+ROW(®É¶¡)),ROW(A1)),10^5)
°}¦C¤½¦¡
¥i¤U©Ô


¤j·§¬O³o¼Ë§a
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD