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

¤À§O±ø¥óÅã¥Ü¦ÜÀx¦s®æ

¤À§O±ø¥óÅã¥Ü¦ÜÀx¦s®æ



§Ú·Q°µ¥X¦p¹Ï¤¤ªºexcel ªí¡A¦ý¤£ª¾¸Ó¦p¦ó¤U¤â...
½Ð°Ý¨ç¼Æ¸Ó«ç»ò¼g¡H

¦^´_ 1# sworder12
¥i¥H¤W¶Ç½d¨ÒÀÉ¡H¤£µM±o¦A³yÀɯuªº«Ü¤£¤è«K¡I
ÁÂÁ¡I

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-7 11:36 ½s¿è

[attach]18635[/attach][attach]18634[/attach][attach]18633[/attach]¦^´_ 1# sworder12
¦bExcel 2003¤U(fig2)
Àx¦s®æA2¿é¤J³¯¦C¤½¦¡(¥HCtrrl+Shift+Enter¿é¤J)
=IF(ISERROR(SMALL(IF((¶}Ãö="OFF")*(ª¬ªp=$A$4),ROW(ª¬ªp),""),COLUMN())),"",SMALL(IF((¶}Ãö="OFF")*(ª¬ªp=$A$4),ROW(ª¬ªp),""),COLUMN()))
Àx¦s®æA5¿é¤J(¥HCtrrl+Shift+Enter¿é¤J)
=IF(ISERROR(SMALL(IF((¶}Ãö="ON")*(ª¬ªp=$A$4),ROW(ª¬ªp),""),COLUMN())),"",SMALL(IF((¶}Ãö="ON")*(ª¬ªp=$A$4),ROW(ª¬ªp),""),COLUMN()))
Àx¦s®æA8¿é¤J(¥HCtrrl+Shift+Enter¿é¤J)
=IF(ISERROR(SMALL(IF((±Ò³¬="Ãö³¬")*(ª¬ªp="ºû­×")*(¦aÂI=$A$7),ROW(ª¬ªp),""),COLUMN())),"",SMALL(IF((±Ò³¬="Ãö³¬")*(ª¬ªp="ºû­×")*(¦aÂI=$A$7),ROW(ª¬ªp),""),COLUMN()))
Àx¦s®æA11¿é¤J(¥HCtrrl+Shift+Enter¿é¤J)
=IF(ISERROR(SMALL(IF((±Ò³¬="Ãö³¬")*(ª¬ªp="¥¿±`"),ROW(ª¬ªp),""),COLUMN())),"",SMALL(IF((±Ò³¬="Ãö³¬")*(ª¬ªp="¥¿±`"),ROW(ª¬ªp),""),COLUMN()))
½Ð°Ñ¦Ò¡I

fig1.JPG (103.25 KB)

fig1.JPG

fig2.JPG (111.58 KB)

fig2.JPG

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-7 11:59 ½s¿è

¦^´_ 1# sworder12
½Ð°Ý¤°»ò±ø¥ó¤UÄÝ©ó¡u²§±`¡v¡H
3#¦^ÂЪº¤º®efig2­Y¬°Excel2007¥H«áª©¥»¡A«h¥i¥ÎIFERROR³B²z(¥i²¤Æ¤½¦¡)¡C
½Ð°Ñ¦Ò¡I

TOP

¦^´_  sworder12
½Ð°Ý¤°»ò±ø¥ó¤UÄÝ©ó¡u²§±`¡v¡H
3#¦^ÂЪº¤º®efig2­Y¬°Excel2007¥H«áª©¥»¡A«h¥i¥ÎIFERROR ...
p212 µoªí©ó 2014-7-7 11:57


¡yÃö³¬¡z ¤@©w¬O±µ¡yºû­×¡z

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-8 08:27 ½s¿è

¦^´_ 5# sworder12
¡u¡yÃö³¬¡z ¤@©w¬O±µ¡yºû­×¡z¡v¡A¤£ÁA¡I
ª½±µ¤W¶Ç­Ó½d¨ÒÀÉ¡AÁקK»~¸Ñ¡I(2#¨Ì­Ó¤Hªº´¢´ú¸ÑÃD)

TOP

¥»©«³Ì«á¥Ñ sworder12 ©ó 2014-7-8 23:22 ½s¿è

ÁÂÁÂp212 ¤j¤jªºÀ°¦£¡Aªþ¤WÀÉ®×...«D±`·PÁÂ
¥t¥~§ÚºÉ¥i¯à¸Ô²Ó»¡©ú§Úªº°ÝÃD¡A§Æ±æ¤£·|Åý±z¬ÝªºÃú·Ù·Ù...


test.rar (8 KB)

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD