ªð¦^¦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 : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD