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

¬O§_¥i¥H§Q¥Î¨ç¼Æ±a¥X­û¤u¤H¼Æ¡H

¬O§_¥i¥H§Q¥Î¨ç¼Æ±a¥X­û¤u¤H¼Æ¡H

¦U¦ì«e½ú¬O§_¥i¥H§Q¥Î¨ç¼Æ±a¥X­û¤u¤H¼Æ¨ºÄ檺¸ê®Æ©O¡H³Â·Ð¤j®a¤F

°ÝÃD.rar (5.74 KB)

¦^´_ 1# s10002096

D2=IF(OR(A2="",C2<>""),"",COUNT($B$2:B2)-COUNT($C$2:C2))

TOP

=IF(SUMPRODUCT(1/COUNTIF($A$2:A2,$A$2:A2))=D1,"",SUMPRODUCT(1/COUNTIF($A$2:A2,$A$2:A2)))

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD