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

[µo°Ý] ¦p¦ó标¥Ü¾ã¦æ³Ì¤j­È¨ç数¤½¦¡

[µo°Ý] ¦p¦ó标¥Ü¾ã¦æ³Ì¤j­È¨ç数¤½¦¡

结ªG¦pªþ¥ó这样

3.rar (5.1 KB)

¿ï¾ÜA2:C17
³]©w®æ¦¡¤Æ±ø¥ó¡A¿ï¥Î¤½¦¡
=$C2=MAX(IF($A$2:$A$17=$A2,$C$2:$C$17))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦h谢ª©¥D !

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD