æè¿°ç好深奥ï¼æé½çä¸æ ã
æææ¯æ ¹æ® Aåçæ°æ®ï¼æ¥åBåæ大ç两个æ°åæ¯å ï¼è¿éæä¹ç解ï¼åé¢ åâè¿åä¸ä¸ªå¼âå°±ä¸æäºã
å¦ä¸å¾ï¼ä½¿ç¨æ°ç»å ¬å¼ï¼
=LARGE((B2:B39)*(A2:A39=A2),1)
ctrl+shift+enter ä¸èµ·æç»æè¾å ¥ï¼
å¦æéè¦ç¬¬äºå¤§çæ°åï¼ä½¿ç¨å ¬å¼
=LARGE((B2:B39)*(A2:A39=A2),2)
å¦æ两个æ°æ®é½å¨ä¸ä¸ªåå æ ¼ï¼éè¦æ³¨æä½¿ç¨ & 符å·è¿æ¥2ä¸ªå ¬å¼å³å¯ã
追é®åé¢åâè¿åä¸ä¸ªå¼ââå°±æ¯æ¯ç»ä¸å¯¹åºçBåæ¯å两大å¼å¨Cåè¿åä»»æä¸ä¸ªæ°ï¼æ¯å¦è¿å1æè åå«è¿å1å2ï¼è¿æ ·æå°±è½çéåºæ¥ãæ¨è¿ä¸ªæ¹æ³æ¯ä¸ç»æ°æ®å¯ä»¥ï¼ä½æ¯æå®é æ°æ®å¾å¤§ï¼ä¸¤ä¸å¤æ¡6åå¤ç»ï¼æéè¦æ ¹æ®æ¯ç»çæ°æ®çéåºBåæ¥ææåå两个çæ°æ®ï¼æè°¢ï¼
æ°æ®å¤ªå¤ç¡®å®ä¸éå使ç¨æ°ç»å ¬å¼ï¼ä½ ç´æ¥ä½¿ç¨éè§è¡¨å¯è½æ´ç®åã
éæ©æ°æ®åºï¼ç¶åæå ¥ ==ãéè§è¡¨ã
ç¶åå°ç¬¬ä¸åæ°æ®è®¾ç½®ä¸ºè¡æ ç¾ï¼ç¶åå¨ æ°å¼é£ééæ©ç¬¬äºåæ°æ®ï¼å¹¶è®¾ç½®å段为 æ大å¼å³å¯ã