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

[µo°Ý] ¥|­Ó¼Æ¦r¶i¦æ¤ñ¹ï°ÝÃD

[µo°Ý] ¥|­Ó¼Æ¦r¶i¦æ¤ñ¹ï°ÝÃD

½Ð°Ý¤j¤j¦p¦ó±N¦P¤@­Ó°Ï°ì¥|­Ó¼Æ¦r¶i¦æ¤ñ¹ï
³Ì¤j¼Æ¦r»P¨ä¥L¼Æ¦r¶i¦æ¤ñ¸û
¦@­p10µ§¸ê®Æ¡A¨Cµ§¦³512¼Æ¦r
¨â­Ó¸¨®t2ªí®æ©³¦â·|¦Û°ÊÅã¥Ü¾í¦â
¦p¸¨®t3¥H¤Wªí®æ©³¦â·|¦Û°ÊÅã¥Ü¬õ¦â
½d¨Ò
  Äæ¦ìR2=43, R3=43,S2=41,S3=---   
  ³Ì¤j¼Æ¬°43,¨ä¤¤S2=41 ¸¨®t¬°2¡A
   S2Äæ¦ì©³¦â·|¦Û°ÊÅã¥Ü¾í¦â
PS:Äæ¦ì---¥Nªí¬°¼Æ¦r0¤£¥Î²z¥L

¥|­Ó¼Æ¦r¶i¦æ¤ñ¹ï°ÝÃD.zip (62.6 KB)

R2
±ø¥ó¤@:
=MAX(OFFSET(R2,-1^ROW($A2)/2,-1^COLUMN(B$2)/2,2,2))-R2=2

±ø¥ó¤G:
=MAX(OFFSET(R2,-1^ROW($A2)/2,-1^COLUMN(B$2)/2,2,2))-R2>2

TOP

­ã´£³¡ªL ¤j¤j
§Ú¥Î±ø¥ó¤@©Î±ø¥ó¤G
­ìÄæ¦ì¼Æ¦r³£·|Åã¥Ü0
¦b³Â·Ð¤j¤j¤F

TOP

¦^´_ 3# jeff5424

Xl0000391.rar (19.83 KB)

¨C¤@°Ï¶ô, ³£­n¶¡¹j2¦æ~~

TOP

·PÁ­㴣³¡ªL
¸g´ú¸Õ¥i¥¿±`¨Ï¥Î

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD