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

[µo°Ý] ­×¥¿¤½¦¡½Ð±Ð

[µo°Ý] ­×¥¿¤½¦¡½Ð±Ð


·Q½Ð±Ð¦U¦ì«e½ú~¦p¦ó­×¥¿¤½¦¡¤~¥i¥H±a¥X¦P®Æ¸¹¤£¦Pµª®×~·PÁÂ{:3_48:}

=IF(COUNTIF(C$1:C2,C2)>COUNTIF(A:A,C2),"",INDIRECT("b"&SMALL(IF(($A$2:$A$1000=C2)*ROW($A$2:$A$1000)=0,9^9,ROW($A$2:$A$1000)),COUNTIF(C$1:C2,C2))))

ctrl+shift+enter

TOP

¦^´_ 2# fengetianxia

«D±`·PÁÂ~ÁöµM½Ñ¦h¤£À´¤§³B~¤p§Ì·|¸ÕµÛºCºC²z¸Ñ

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD