±ø¥ó¤Æ®æ¦¡¥i¥H¨Ï¥Îaddress³oºØ¨ç¼Æ¶Ü
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
±ø¥ó¤Æ®æ¦¡¥i¥H¨Ï¥Îaddress³oºØ¨ç¼Æ¶Ü
ªþÀɤ¤§Ú·QnÅý¤£¦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§Ú·Qnªº
¬O§Úªº¨ç¼Æ¿ù»~¶Ü?
Book1.rar (3.89 KB)
|
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|