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

[µo°Ý] ±N¬Û¦P¸ê®Æ±Æ¦b¦P¤@¦C ,¤£¬Û¦P¦Û°Ê´¡¤JªÅ¥Õ¦C

[µo°Ý] ±N¬Û¦P¸ê®Æ±Æ¦b¦P¤@¦C ,¤£¬Û¦P¦Û°Ê´¡¤JªÅ¥Õ¦C

½Ð°Ý²³excel¤j¯«

¦p¦ó±N¬Û¦P¸ê®Æ±Æ¦b¦P¤@¦C,¦pªG¹J¨ì¤£¬Û¦Pªº¸ê®Æ´N¦Û°Ê´¡¤J¤@ªÅ¥Õ¦C

¦pªþ¥ó


¥ýÁÂÁ¦U¦ì¤j¤j©âªÅ¦^ÂÐm(_ _)m

°ÝÃD.zip (10.72 KB)

L2,O2,R2=IF(M2="","",SUMPRODUCT((M$2:M2<>"")*1))
M2,P2,S2=IF(ISNA(MATCH(REPT(CHAR(96+ROW(A1)),2),B:B,)),"",REPT(CHAR(96+ROW(A1)),2))

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD