æ¬é®é¢é¾ç¹ä¸å¨äºç»è®¡æ个æ°åç个æ°ï¼ä¸ä¸ªç®åçcontifå°±å¯ä»¥äºãèæ¯é¾å¨ç»å®çåºåä¸æåªäºæ°åï¼ä¸éå¤çæ°åã
å¦å¾ï¼A1:E8ä¸ææ°åï¼é¨åæ°åéå¤ãç°å¨å¨Gåå æååºA1:E8ä¸ä¸éå¤çæ°åï¼
G2=INDIRECT(TEXT(MIN(IF((COUNTIF($G$1:G1,$A$1:$E$8)=0)*($A$1:$E$8>""),ROW($1:$8)*100+COLUMN(A:E),9999)),"r0c00"),)&""
åæ¶æCtrl+Shift+Enterä¸é®è¾å ¥æ°ç»å ¬å¼ï¼ä¸æå°åºç©ºç½åå æ ¼
åå¨Håç»è®¡å个æ°ååºç°ç次æ°ï¼
H2=COUNTIF($A$1:$E$8,G2)
ä¸æå°ä¹Gåä¸æ ·çè¡æ°ã