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

[µo°Ý] ¸õ¦C§R°£­«½Æ+±Æ§Ç

[µo°Ý] ¸õ¦C§R°£­«½Æ+±Æ§Ç


¸õ¦C§R°£­«½Æ+±Æ§Ç.rar (3.37 KB)
»Ý¨D¡J
B12=§R°£$B3:$AN3©M$B6$AN6ªº­«½Æ­È+±Æ§Ç(¥Ñ¤p¦Ó¤j)¡C

½Ð±ÐB12ªºExcel2003ª©¨ç¼Æ¤½¦¡¡CÁÂÁÂ

¥»©«³Ì«á¥Ñ papaya ©ó 2020-4-28 18:43 ½s¿è

¦^´_ 1# papaya

¸õ¦C§R°£­«½Æ+±Æ§Ç-v1.rar (4.07 KB)
¦³¦b"ª¾ÃÑ+"ª¦¨ìÃþ¦ü»Ý¨Dªº¤½¦¡¸Ñ¡A­×¥¿¬°»Ý¨Dªº¦ì§}«á~
B12
=IF(MAX(A$12:A12)=MAX($B$3:$AN$3,$B$6:$AN$6),"",SMALL(($B$3:$AN$3,$B$6:$AN$6),1+FREQUENCY(($B$3:$AN$3,$B$6:$AN$6),A12)))
¦ý¶W©Ôªº³¡¤À·|¦A­«·sÅã¥Ü¬Û¦P¼Æ­È¡AµLªk¹³B11¶W©ÔªºÀx¦s®æ·|Åã¥ÜªÅ¥Õ¡C
·Ð½Ð¦U¦ì¤j¤j«ü¾É©M­×¥¿¡CÁÂÁ !

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2020-4-29 11:21 ½s¿è

¦^´_ 2# papaya

B11:=IF(MAX($A11:A11)=MAX($B$3:$AN$3,$B$4:$AN$4),"",SMALL(($B$3:$AN$3,$B$4:$AN$4),1+FREQUENCY(($B$3:$AN$3,$B$4:$AN$4),A11)))

B12:=IF(MAX($A12:A12)=MAX($B$3:$AN$3,$B$6:$AN$6),"",SMALL(($B$3:$AN$3,$B$6:$AN$6),1+FREQUENCY(($B$3:$AN$3,$B$6:$AN$6),A12)))

TOP

¦^´_ 3# ­ã´£³¡ªL
­ì¨Ó¬O$ªº¦ì¸m¿ù¤F^^"
ÁÂÁ±zªº­@¤ß«ü¾É~·P®¦

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD