- ©«¤l
- 617
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 662
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-3-7
|
¥»©«³Ì«á¥Ñ p212 ©ó 2015-8-12 15:45 ½s¿è
¦^´_ 1# dnadark
1.¦b¡u®w¦s¡v¤u§@ªí¤¤¡A¿ï¨ú¤Ï¥Õ¸ê®Æ½d³ò(¨Ò¦p½d¨ÒÀɪºA1:D12)¡A«ö¡uCtrl+Shift+F3¡vÁä¡A¿ï¾Ü¥H¡u³»ºÝ¦C¡v¬°¦WºÙ¡A¶i¦æ©w¸q¦WºÙ¡C
2.¦b¡u¬d¸ß¡v¤u§@ªí¤¤ªºÀx¦s®æB2¿é¤J
=IFERROR(SUMPRODUCT(($A2=«~¸¹)*(INDEX($C2:$M2,MATCH(TRUE,$C2:$M2,0)+1)=Àx¦ì)*¥X®w),"")
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I |
|