¦h±ø¥óªº¬d¸ß(¾Ç¾ú+įÅ)±o¥X¼úª÷
- ©«¤l
- 248
- ¥DÃD
- 76
- ºëµØ
- 0
- ¿n¤À
- 331
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- kaohsiung
- µù¥U®É¶¡
- 2013-6-10
- ³Ì«áµn¿ý
- 2020-7-3
|
¦h±ø¥óªº¬d¸ß(¾Ç¾ú+įÅ)±o¥X¼úª÷
°ÝÃD¡G¦h±ø¥óªº¬d¸ß(¾Ç¾ú+įÅ)±o¥X¼úª÷¡A¥BįŨC¦~¸õ¤@¯Å¡A¨ì³»¤£¦A¸õ |
-
-
°ÝÃD22.rar
(7.91 KB)
|
§Æ±æ¤ä«ù!
|
|
|
|
|
- ©«¤l
- 248
- ¥DÃD
- 76
- ºëµØ
- 0
- ¿n¤À
- 331
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- kaohsiung
- µù¥U®É¶¡
- 2013-6-10
- ³Ì«áµn¿ý
- 2020-7-3
|
·P·Å®@¡C¦³§A̯u¦n¡A¦n¹³¨S¦³¦^µª¤£¤Fªº°ÝÃD¡A¯u¬O¤F¤£°_¡A§Æ±æ¦³¤@¤Ñ¤]¦³³oÓ¯à¤O¡C |
|
§Æ±æ¤ä«ù!
|
|
|
|
|
- ©«¤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-4-15 13:48 ½s¿è
¦^´_ 3# s7659109
À³¥Î©óOffice 2003ª©¡AÀx¦s®æQ3«Øijקאּ
=IF(ISERROR(OFFSET($A$1,MATCH(P3,įÅ,0),MATCH($L3&"¼úª÷",$A$1:$E$1,0)-1)),0,OFFSET($A$1,MATCH(P3,įÅ,0),MATCH($L3&"¼úª÷",$A$1:$E$1,0)-1)) |
|
|
|
|
|
|
- ©«¤l
- 248
- ¥DÃD
- 76
- ºëµØ
- 0
- ¿n¤À
- 331
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- kaohsiung
- µù¥U®É¶¡
- 2013-6-10
- ³Ì«áµn¿ý
- 2020-7-3
|
¦p¦óoffice¬O2003¬O§_n×¥¿¡H |
|
§Æ±æ¤ä«ù!
|
|
|
|
|
- ©«¤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-4-15 12:02 ½s¿è
¦^´_ 1# s7659109
´N½d¨ÒÀɸѡG
1¡B½Ð°é¿ïįÅ(A1:A19)¡B¾Ç¾ú(G1:G5)¡B³»Á~įÅ(I1:I5)¡A«öCtrl+Shift+F3¡A¥H¡u³»ºÝ¦C¡v¬°½d³ò¦WºÙ¡C
2¡B°²³]¥HNÄæįŬ°baseline (½d¨ÒÀÉ¥¼»¡©ú¦óªÌ¬°baseline¡A¬G°²³]¥H103¦~¸ê®Æ¬°baseline)¡C
Àx¦s®æP3¿é¤J¤½¦¡
=IF($N3+(P$1-$N$1)>SUMPRODUCT((¾Ç¾ú=$L3)*(³»Á~įÅ)),SUMPRODUCT((¾Ç¾ú=$L3)*(³»Á~įÅ)),$N3+(P$1-$N$1))
Àx¦s®æQ3¿é¤J¤½¦¡
=IFERROR(OFFSET($A$1,MATCH(P3,įÅ,0),MATCH($L3&"¼úª÷",$A$1:$E$1,0)-1),0)
3¡B¦P®É¤Ï¥ÕÀx¦s®æP3»PÀx¦s®æQ3¡A¦V¥k¦V¤U½Æ»s¤½¦¡¡C
½Ð°Ñ¦Ò¡I
µù¡GÀx¦s®æL5½Ð§ó§ï¬°¡u¾Ç¤h¡v¡A¥H§Q©ó»PÀx¦s®æD1¸ê®Æ©IÀ³¡C |
|
|
|
|
|
|