- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ 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)
-
-
fig2.JPG
(111.58 KB)
|