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

[µo°Ý] ½Ð°Ý¦p¦ó§ä¥X­«½Æ§å¸¹

selectionchange
¿ï¨ú¦ì¸m§ïÅÜ®ÉIJµoªºµ{§Ç
change
¬OÀx¦s®æ¤º®e(­È)§ïÅÜ®ÉIJµoªºµ{§Ç
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 21# Hsieh


    ÁÂÁª©¥Dªº¸Ñµª
¥t¥~­Y¥ÎVBA¦b¿é¤J¦³­«½Æ§å¸¹®É
¶ÈÅã¥Ü"­«½Æ§å¸¹"¦ý¬O¤£·|ª¾¹D¥t¤@­Ó­«½Æ§å¸¹ªº¦ì¤l

­«½Æ§å¸¹-1.gif
2010-7-11 10:22


ÁÙ¬OÁÂÁ±zÀ°§Ú§ï¦nµ{¦¡...

TOP

g13
®æ¦¡¤Æ±ø¥ó=COUNTIF($G$13G13,$G14)>=1
gong µoªí©ó 2010-7-7 08:45



    ÁÂÁÂGONGª©¥Dªº³]©w®æ¦¡¤Æ
·í­«½Æ§å¸¹¥X²{®É·|Åã¥Ü"ÃC¦â"
¦ý¬O¿é¤J·sªº§å¸¹«á...Àx¦s®æ¤ºªºÃC¦â¤£·|®ø¥¢
¬O§Úªº®æ¦¡³]©w¿ù»~¶Ü?

­«½Æ§å¸¹-2-1.gif
2010-7-11 10:26


­«½Æ§å¸¹-2-2.gif
2010-7-11 10:26


ÁÙ¬O«ÜÁÂÁ±z...

TOP

³Ì«á¥t¥~¸Õ
   3.¥¿¦b¸Õ¥t¤@ºØ¥[Äæ¦ì(¬JµM³£­n¥[Äæ¦ìªº¸Ü)¥Î¤½¦¡Åã¥Ü"­«½Æ§å¸¹"¦bÀx¦s®æ¤¤ª½±µÅã¥Ü


­«½Æ§å¸¹-3.gif
2010-7-11 10:28

¥i¥Hª¾¹D­«½Æ§å¸¹ªºÀx¦s®æ..¦ý¬O¬O¥²¶··s¼W¤@­ÓÄæ¦ì¥h§P§O..
¦pªG·Q­n¦b§å¸¹ªºÀx¦s®æ¤¤..ª½±µÅã¥Ü"­«½Æ§å¸¹"¤j·§¤£¦æ§a!!
·PÁÂ¥ý¶iwqfzqgk¤Îª©¥Dªº¦^¤å...

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2010-7-11 12:48 ½s¿è

¤£·|§a!
®æ¦¡¤Æ±ø¥ó³]©w,¦b¥»¦C¤§«e¦pªG¦³­«½Æ¥»Àx¦s®æ¤º®eªÌ,¤~·|¥[©³¦â
ÃC¦âµLªk®ø¥hªí¥Ü«e­±ÁÙ¦³­«ÂЭÈ

°£«D¤½¦¡³]¬°¤â°Ê

¸É¥R»¡©ú:§Ú®æ¦¡¤Æ±ø¥ó¬O±q14¦C¶}©l³]°_,¤£¬O13¦C
¦pªG±q13¦C¶}©l§Y¥]§t¥»¨­,¤½¦¡­n§â>=1,ªº"="®³±¼
¤~·|¥¿½TÅã¥Ü
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2010-7-11 12:57 ½s¿è
³Ì«á¥t¥~¸Õ
   3.¥¿¦b¸Õ¥t¤@ºØ¥[Äæ¦ì(¬JµM³£­n¥[Äæ¦ìªº¸Ü)¥Î¤½¦¡Åã¥Ü"­«½Æ§å¸¹"¦bÀx¦s®æ¤¤ª½±µÅã¥Ü



...
PD961A µoªí©ó 2010-7-11 10:35


o13
=if(countif($g$13:$g13,$g13)=1,"","­«ÂÐ")
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 25# gong


    ÁÂÁÂGONGª©¥D
Àɮ׳]©w®æ¦¡¬O¤@¼Ëªº(¨S¦³¥t¥~¤â°Ê³]©w)
¦ý¬O¥N¥Xªº­È´N¬O©Ç©Çªº
1.gif
2010-7-11 16:12


gong-1.rar (22.51 KB)

ÁÂÁ±z

TOP

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-7-11 16:18 ½s¿è

¦^´_ 26# gong


    ¥t¥~±z»¡­×¥¿
  ¦pªG±q13¦C¶}©l§Y¥]§t¥»¨­,¤½¦¡­n§â>=1,ªº"="®³±¼
¤~·|¥¿½TÅã¥Ü
µ²ªG³]©w«á¬O¤£·|Åܦâ...¨BÆJ­þ¸Ì¦³°ÝÃD?
·PÁ±z....

2.gif
2010-7-11 16:15


gong-2.rar (22.42 KB)



¥t¥~ÁÂÁ±zo13
=if(countif($g$13:$g13,$g13)=1,"","­«ÂÐ") ªº¤½¦¡..ÁÂÁÂ

TOP

¦^´_ 27# PD961A


    g13ªº®æ¦¡¤Æ±ø¥ó
=COUNTIF($G$13:$G13,$G14)>=1
¸ê®Æ¿ù¤F¤@¦ì
À³§ï¦¨
=COUNTIF($G$13:$G13,$G13)>1
©Î§ï¬°
=COUNTIF($G$12:$G12,$G13)>=1

gong.rar (41.36 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2010-7-11 19:09 ½s¿è
¦^´_  gong


    ¥t¥~±z»¡­×¥¿
  ¦pªG±q13¦C¶}©l§Y¥]§t¥»¨­,¤½¦¡­n§â>=1,ªº"="®³±¼
¤~·|¥¿½TÅã¥Ü
µ² ...
PD961A µoªí©ó 2010-7-11 16:16


§Aªºg13®æ¦¡¤Æ±ø¥ó³]
=COUNTIF($G$13:$G53,$G54)>1
³o¼Ëªº½d³ò¿ù¤F,±ø¥ó¤Ñ®t¦a»··íµMµLªkÅã¥Ü¥¿½T­È


À³¸Ó¬O
=COUNTIF($G$13:$G13,$G13)>1
³o¼Ëªº·N«ä¬O±q²Ä13¦C°_¥]§t¥»¨­¦pªG¦³1­Ó¥H¤Wªº­«ÂÐ,«h¶ñ¤W±ø¥ó®æ¦¡ªºÂÅ©³¦â
(14¦C¥H¤Uªº¸ê®Æ¦b¥»¤½¦¡¤º¼È®É¤£­p)
§A­ì¨Óªº¤½¦¡½d³ò¤£¥¿½T,±ø¥ó¦ì¸m¤]¤£¹ï
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD