- ©«¤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-3-6 11:51 ½s¿è
¦^´_ 1# a60981e1113
Q1¸Ñ¡G
1¡B¦bCÄæ«Ø¥ß»²§U¸ê®Æ¡GÀx¦s®æC2¿é¤J°}¦C¤½¦¡ =IF(B2=$D$1,MAX(IF(B$1:B1=B2,C$1:C1))+1,"")¡A¦A¦V¤U½Æ»s¤½¦¡¡Aª`·N°}¦C¤½¦¡¶·¥HCtrl+Shift+Enter¿é¤J¡C
2¡BÀx¦s®æE2¿é¤J¤½¦¡ =IFERROR(INDEX($A$1:$A$50,MATCH(ROW(1:1),$C$1:$C$50,0)),"")¡A¦A¦V¤U½Æ»s¤½¦¡¡C
3¡B½Ð¦bÀx¦s®æD1¿é¤J¡u¯f°²¡v¡B¡u¥ð°²¡v©ÎªÅ¥Õ(¤£¿é¤J¥ô¦óÈ)¡A§Y¥i±o¨ì±znªºµ²ªG¡C(¹Ï¥Ü¬°Àx¦s®æD1¥¼¿é¤J¸ê®Æ¤§µ²ªG)
Q2¸Ñ¡G
¨ú¥XAÄæ°ß¤@È¡GÀx¦s®æG2¿é¤J°}¦C¤½¦¡=IFERROR(INDEX($A$2:$A$50,MATCH(0,COUNTIF($G$1:G1,$A$2:$A$50),0)),"")
½Ð°Ñ¦Ò¡I
µù¡GQ1¸Ñ_1»²§U¸ê®Æ¤½¦¡¤§·§©À¡A½Ð°Ñ¦Ò http://forum.twbts.com/thread-11103-1-1.html (·PÁÂHsieh¶W¯Åª©¥D»PML089ª©¥Dªº«ü¾É) |
-
-
Fig.JPG
(65.36 KB)
|