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

[µo°Ý] ¦p¦ó¥Î¨ç¼Æªº¤è¦¡§ä¥X¦U²Õªº³Ì¤p­È¤Î³Ì¤j­È

[µo°Ý] ¦p¦ó¥Î¨ç¼Æªº¤è¦¡§ä¥X¦U²Õªº³Ì¤p­È¤Î³Ì¤j­È

±z¦n
§Ú¸Ó¦p¦ó¥Î¨ç¼Æªº¤è¦¡§ä¥Xªþ¥ó¤¤¦U²Õªº³Ì¤p­È¤Î³Ì¤j­È
ÁÂÁÂ!!

Book1.rar (13.01 KB)

¦^´_ 1# pupai

G2=INDEX($A$2:$A$906,MATCH($F2,$B$2:$B$906,0),)
H2=LOOKUP(F2+0.1,$B$2:$B$906,$A$2:$A$906)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# pupai


¤èªk¤@: ¨Ï¥Î DMIN »P DMAX
=DMIN(Range,$A$1,INDIRECT("¤À²Õ"&$F8))
=DMAX(Range,$A$1,INDIRECT("¤À²Õ"&$F8))
¦ý¶·¥ý¨Ï¥Î ´¡¤J/¦WºÙ/©w¸q,±NCriteria³]¸m¦n¦p¤U¹Ï:
setCri.gif
Àɮצp¤U:
¤èªk¤@.zip (20.91 KB)

TOP

¦^´_ 1# pupai


¤èªk¤G: µ½¥ÎSumproduct¤½¦¡
1. ¥ý¨ú±o¦U¤À²Õ±Æ§Ç
¥Ñ¨ì¤p¤j±Æ§Ç=SUMPRODUCT((¤À²Õ=$B4)*(½s¸¹<$A4))+1
¥Ñ¤j¨ì¤p±Æ§Ç=SUMPRODUCT((¤À²Õ=$B4)*(½s¸¹>$A4))+1

2. ¦A§Q¥Î±Æ§Ç­È¨ú±o¦U²Õ³Ì¤p»P³Ì¤j­È
³Ì¤p­È=SUMPRODUCT((¤À²Õ=$H4)*(RankLtoH=1)*½s¸¹)
³Ì¤j­È=SUMPRODUCT((¤À²Õ=$H4)*(RankHtoL=1)*½s¸¹)

ªþ¥ó¦p¤U:
¤èªk¤G.zip (65.48 KB)

TOP

¦^´_ 2# Hsieh


    ÁÂÁª©¤jªºÀ°¦£

TOP

¦^´_ 4# infoverdad


    ÁÂÁ infoverdad ªºÀ°¦£

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD