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

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

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

¤½¦¡½Ð±Ð.jpg
2017-8-11 09:06

·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 : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD