å¯ä»¥ç¨ï¼ =INDEX(æ¾ç¤ºå¼çèå´,sumproduct((èå´=æ¡ä»¶)*(èå´=æ¡ä»¶)*ROW(INDIRECT("1:"&COUNTA(æ¾ç¤ºå¼çèå´)))) æï¼ =VLOOKUP(æ¡ä»¶1&æ¡ä»¶2&æ¡ä»¶3,IF({1,0},èå´1&èå´2&èå´3ï¼æ¾ç¤ºå¼çèå´ï¼2ï¼0ï¼ è¿ä¸ªæ¯æ°ç»å
¬å¼ï¼æä¸é®ã
温馨提示:答案为网友推荐,仅供参考