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

[µo°Ý] ±ø¥ó¦¡®æ¦¡³]©w-³Ì«á¤@µ§¸ê®ÆµÛ¦â

[µo°Ý] ±ø¥ó¦¡®æ¦¡³]©w-³Ì«á¤@µ§¸ê®ÆµÛ¦â

¤j¤j¦n,
±ø¥ó¡G
1) cÄæ¤é¦L & bÄæ¼ÐÅҥ涰ªº³Ì«á¤@µ§¸ê®Æ ¹ïÀ³ªºGÄæµ²¾l>0,«h§âA:HµÛ¦â
2) BÄæ¼ÐÅÒ¤£¬O°ß¤@,¥¦·|­«½Æ¨Ï¥Î,¦ýCÄæ¤é´Á,«h¦b¶i³f¼Æ¶q¥Î§¹«á,´N¤£·|­«½Æ¥X²{

ex:
1) 8/10¥u¦³¤@ºØB¼ÐÅÒ,¦Ó8/10³Ì«á¤@µ§¸ê®ÆGÄæ=0.....¤£µÛ¦â
2) 8/12¦³¤GºØ¼ÐÅÒ Ä±&A,8/12ı,³Ì«á¤@µ§¸ê®ÆGÄæ=6.....µÛ¦â
8/12A,³Ì«á¤@µ§¸ê®ÆGÄæ=0.....¤£µÛ¦â

¥H¦¹Ãþ±À...
½Ð°Ý¦p¦ó¥Î±ø¥ó¦¡®æ¦¡³]©w,§â²Å¦X±ø¥óªºA:HµÛ¦â ±ø¥ó¦¡®æ¦¡³]©w_0813.rar (9.17 KB)

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2020-8-14 09:50 ½s¿è

®æ¦¡±ø¥ó:
=IF($G3=0,,ISNA(MATCH(1,($B3=$B4:$B199)*($C3=$C4:$C199),)))

©Î/§¹¾ã¨Ç:B.C¥¼¿é¤J®É,¤£§@§PÂ_
=IF(OR($B3="",$C3="",$G3=0),,ISNA(MATCH(1,($B3=$B4:$B199)*($C3=$C4:$C199),)))

B199, C199 ¨Ì¹ê»Ú¸ê®Æ¥i¯à¦æ¼Æ¦Û¦æ­×§ï,
¸ê®Æ¦æ¼Æ­Y¤Ó¦h, ¥i¯à³y¦¨¥dÀɲ{¹³!!!

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD