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

[µo°Ý] ¦p¦ó§PÂ_¥þ³¡²Å¦Xªº±ø¥ó®æ part2

[µo°Ý] ¦p¦ó§PÂ_¥þ³¡²Å¦Xªº±ø¥ó®æ part2

¦U¦ì¤j¤j¡A§Ú·Q»s§@¤@­Ó¦b¤À­¶1¬°¿é¤J±ø¥ó®æ¡A¤À­¶2¬°°Ñ¦Ò°Ï
­Y¤À­¶1ªº¦æ§¹¥þ²Å¦Xªº¸Ü¡AÀ°§Ú¿é¥Xok,¡A§_«h¬°ng

¨ä¤¤´X­ÓÀt¤ò°Ï¡A¤À­¶2¤£¬O¬Û³sªº¸ê®Æ(¦³¶¡¹j)
¥t¥~§Úªº¤å®Ñ¨t²Î¬Ooffice2003¡A¤§«e¦³«e½ú´£¨Ñªº»yªk¤£¬O¤£¤ä´©2003´N¬O¤£¤ä´©¤À­¶¡A©Ò¥H¤£ª¾¹D¦³¨S¦³¤H¥i¥HÀ°§Ú¸Ñ¨M¤@¤U!!
ÁÂÁ ·s¼W Microsoft Excel ¤u§@ªí_ref.rar (8.37 KB)






¤§«e«e½ú¦^µªªº¤º®e¡A¦³¤H¥i¥HÀ°§Ú±µÄò¦^µª¤]¤£¿ù¡AÁÂÁÂ!!!
http://forum.twbts.com/thread-17610-1-1.html

=IF(OR(MMULT(COUNTIF(OFFSET(°Ñ¦Ò!A$2,ROW($2:$14)-2,{0,2,4,6,8}),A2:E2),{1;1;1;1;1})=5),"OK","NG")

TOP

¦^´_ 2# ­ã´£³¡ªL

ÁÂÁª©¤jÀ°¦£¡A´ú¸Õok¨S¦³°ÝÃD¡A
½Ð°Ý¤@¤U¡A§Ú¥i¥H«ç»ò§ï¡AÅܦ¨¤£­­©w°Ñ¦Ò°Ïªº¤ñ¼Æ¶Ü??(¨Ò¦p¡G§Ú¤µ¤Ñ¥i¯à¤ñ¹ï¦Ü14¦æ¡A¦ý§Ú¤§«á¥i¯à¤S·|¼W¥[¤ñ¹ï¦æ¼Æ¡A¦Ü50¦æ)
¨Ò¥~¡A¦pªG§Úªº¶¡®æ¨S¦³¤@©w¡A¦³®É­Ô¸õ¤@®æ¡A¦³®É­Ô¸õ¤­®æ¡A«ç»ò§ï¤ñ¸û¤è«K©O???

TOP

¦^´_ 3# lichang


OFFSET(°Ñ¦Ò!A$2,ROW($2:$14)-2,{0,2,4,6,8})

ROW($2:$14)-2¡@¦C¼Æ
{0,2,4,6,8}¡@Äæ¦ì

TOP

¦^´_ 4# ­ã´£³¡ªL


¤j¤j¡A§Úµo²{§Úªº°ÝÃD¦b­þ¸Ì¤F¡A³Â·Ð¦bÀ°§Ú¸Ñ¨M¤@¤U
¦pªG§Úªº°Ñ¦Ò°Ï¤å¦r¬O"   <0 "¡A¥L«KµLªk§PÂ_¡A§Ú¸Ó¦p¦ó­×§ï¤~¥i¥H§PÂ_¯S®í²Å¸¹??

¥t¥~¡A§Úªº¿é¤J°Ï¡A­Y¤]¬O¦³¶¡®æ¿é¤Jªº¸Ü(¤£µ¥¶¡®æ)¡A¤S­n«ç»ò­×§ï©O????(¥i¥H¤@­Ó¤@­Ó«ü©w¨SÃö«Y)

¯u¬O³Â·Ðª©¤j¤F!!!ÁÂÁÂ!!

TOP

¦^´_ 4# ­ã´£³¡ªL


½Ð°Ýª©¥D¡A§Úªº°ÝÃD¦³¸Ñ¶Ü¡H¿é¤J°Ï¤]¬O¦³¶¡¹jªº

TOP

¦^´_ 6# lichang


°ÝÃD¨S¤H¦^µª, ¤j³¡¥÷¬O[°Ý°ÝÃD]¥»¨­´N¬O°ÝÃD, ¤£©ú¥Õ°ÝÃD, ·íµMµL±q¦^µª!
¦pªG¹ï¤½¦¡¤£¬O«Ü¤F¸Ñ, ³Ì¦n¥H¹ê»ÚÀɮתº°ÝÃD§¹¥þ´£¥X, §_«h®³¨ì¤½¦¡¤S§ï¤£¤F, ¦^µªªº¤H¤@ª½¸ò©«¸É¥R, «Ü¶O®É¶O¤O,

½Ð¦A¸Ô²Ó´£¥X»Ý¨D¤ÎÀÉ®×, ¥u­n¦³¸Ñ, ¬Û«H¦³¨ä¥L¤j¤j·|´£¨Ñ°Ñ¦Òªº!

TOP

¦^´_ 7# ­ã´£³¡ªL

¬Oªº¤j¤j¡A§Ú·s¼Wªþ¥ó¨Ã­«·s½s±Æ§Úªº°ÝÃD
§Úªº°ÝÃD¬O¡G"¿é¤J°Ï"²{¦b¤]­n§ï¦¨«D¬Û³s¦b¤@°_ªº¸ê®Æ¡A¤]´N¬O¤£µ¥¶¡®æªºªº¿é¤J°Ï¡A½Ð°Ý­n«ç»ò§ï¤~¦n©O???
ÁÂÁ¤j¤jªº­@¤ß¦^´_!!!

·s¼W Microsoft Excel ¤u§@ªí_ref.rar (9.03 KB)

TOP

½Ð°Ý¦U¦ì¡A¯àÀ°§Ú¬Ý¤@¤U°ÝÃD¶Ü???
°ÝÃD¦b¤K¼Ó

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD