ªð¦^¦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 : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD