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

´M§ä³f«~ªº¦³®Ä´Á­­(³Ì¤j­È©M³Ì¤p­Èªº°ÝÃD...)

´M§ä³f«~ªº¦³®Ä´Á­­(³Ì¤j­È©M³Ì¤p­Èªº°ÝÃD...)

¦U¦ì¤j¤j, ¤p©f¥ý¦U¤j®a½Ð¦w:)

ª¬ªp : ¤½¥q¦³¨â­Ó­Ü®w(­Ü®wA & ­Ü®wB), ­Ü®wA ¬O¦¬³f©M°e³f, ­Ü®wB¥u­t³d¦¬³f, ¥ÎEXCEL¬ö¿ý®w¦s...
§Ú­Ì¥Í²£°Ó¨C¦¸¨Óªº³f­¹¥Î´Á­­³£¤£Ã­©w...¤W¥q§Æ±æ¯à°÷±N­Ü®wA¾ã²z¬°¦s©ñ­¹¥Î´Á­­¤ñ¸û¦­ªº³f,
­Ü®wB¬°¦s©ñ­¹¥Î´Á­­¤ñ¸û«áªº, ½Ð°Ý¦³¿ìªk¦bEXCEL ¸Ì°µ¥X¤@­Ó¬d¸ßªí, ¿é¤J³fª«½s¸¹´N¥i¥H¦C¥X

1) ­Ü®wA ­¹¥Î´Á­­ªº³Ì¤j­È
2) ­Ü®wB ­¹¥Î´Á­­ªº³Ì¤p­È

½Ð«ü±Ð:'(


®w¦s.rar (1.93 KB)

B2¿é¤J
=LARGE(IF(­Ü®wA®w¦s!$A$2:$A$1000=A2,­Ü®wA®w¦s!$C$2:$C$1000,0),1)
«öCtrl+Shift+Enter

C2¿é¤J
=SMALL(IF(­Ü®wB®w¦s!$A$2:$A$1000=A2,­Ü®wB®w¦s!$C$2:$C$1000,99999999),1)
«öCtrl+Shift+Enter

±NB2»PC2©¹¤U©Ô§Y¥i
YOYO

TOP

¦^´_ 2# yanto913


¥»¥H¬°³o»ò±ß¤F, ¥´ºâ©ú¤Ñ¦A¦^¨Ó....
©~µM³o»ò§Ö´N±o¨ì¸Ñµª!!! :D ·P¿E¤£ºÉ!!!! ±ß¦w!!!

TOP

¦^´_ 3# ³·±ö®Q


¤£«È®ð!¤£¹L´£¿ô¤@¤U
§A­nª`·NA­Ü®w³fª«ªºµ§¼Æ¦³¨S¦³¯}1000µ§¡A¤W­±ªº¤½¦¡¥u·|§PÂ_1000¦C
¦pªG­n«OÀI¤@ÂI´N
B2¿é¤J
=LARGE(IF(­Ü®wA®w¦s!$A$2:$A$65536=A2,­Ü®wA®w¦s!$C$2:$C$65536,0),1)
«öCtrl+Shift+Enter
C2¿é¤J
=SMALL(IF(­Ü®wB®w¦s!$A$2:$A$65536=A2,­Ü®wB®w¦s!$C$2:$C$65536,99999999),1)
«öCtrl+Shift+Enter
±NB2»PC2©¹¤U©Ô§Y¥i
YOYO

TOP

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