ªð¦^¦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 : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD