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

±ø¥ó¤Æ®æ¦¡¥i¥H¨Ï¥Îaddress³oºØ¨ç¼Æ¶Ü

±ø¥ó¤Æ®æ¦¡¥i¥H¨Ï¥Îaddress³oºØ¨ç¼Æ¶Ü

ªþÀɤ¤§Ú·Q­nÅý¤£¦P¶Ç²¼½s¸¹¹º½u°Ï¤À
¦pªG¨Ï¥Î$B1<>$B2¬O¥i¥H¹F¦¨±ø¥ó
¦ý¬O¦pªG¦³¨ä¤¤¤@¦æ§R±¼¨º¤@­Ó³¡¥÷¤£·|§ó·s
=AND(ROW()>5,INDIRECT(ADDRESS(ROW(),2,3))<>INDIRECT(ADDRESS(ROW()+1,2,3)))
¦]¦¹§Ú¨Ï¥Î¤W­±ªº¤è¦¡
¥i¬Oµ²ªG«o¤£¬O§Ú·Q­nªº
¬O§Úªº¨ç¼Æ¿ù»~¶Ü?



Book1.rar (3.89 KB)
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD