- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 197
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-9-7
![2023¦~¥þ¶Ô¼ú³¹ 2023¦~¥þ¶Ô¼ú³¹](images/common/2023.png) ![2022ªê¦~¥þ¶Ô¼ú³¹ 2022ªê¦~¥þ¶Ô¼ú³¹](images/common/hu.gif) ![2021¤û¦~¥þ¶Ô¼ú³¹ 2021¤û¦~¥þ¶Ô¼ú³¹](images/common/niu.gif) ![2020¹«¦~¥þ¶Ô¼ú³¹ 2020¹«¦~¥þ¶Ô¼ú³¹](images/common/shu.gif) ![2019 ½Þ¦~¥þ¶Ô¼ú³¹ 2019 ½Þ¦~¥þ¶Ô¼ú³¹](images/common/zhu.gif) ![2018 ª¯¦~¥þ¶Ô¼ú³¹ 2018 ª¯¦~¥þ¶Ô¼ú³¹](images/common/gou.gif) ![2017 Âû¦~¥þ¶Ô¼ú³¹ 2017 Âû¦~¥þ¶Ô¼ú³¹](images/common/ji.gif) ![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif) ![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2013³D¦~¥þ¶Ô¼ú³¹ 2013³D¦~¥þ¶Ô¼ú³¹](images/common/she.gif) ![2012Às¦~¥þ¶Ô¼ú³¹ 2012Às¦~¥þ¶Ô¼ú³¹](images/common/long.gif) ![½×¾Â°^Äm¾±³¹ ½×¾Â°^Äm¾±³¹](images/common/medal5.gif) ![¼ö¤ß¤½¯q¾±³¹ ¼ö¤ß¤½¯q¾±³¹](images/common/medal15.gif) ![2011¨ß¦~¥þ¶Ô¼ú³¹ 2011¨ß¦~¥þ¶Ô¼ú³¹](images/common/tu.gif)
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-2-21 10:30 ½s¿è
¦^´_ 1# bvge
©w¸q¦WºÙ
x=ª÷ÃB!$F$3:$AC$3
y=OFFSET(ª÷ÃB!$A$3,1,MATCH('¥X³f³æ(¤½¦¡)'!$H$6,ª÷ÃB!$3:$3,0)-1,146,)
**************************************
H6ÅçÃÒ:²M³æ=x
**************************************
C1="ªA°È¹s¥ó¥æ³f©ú²Óªí ("&MID(H6,FIND(CHAR(10),H6),256)&")"
A8:C8°}¦C¤½¦¡
=IF(ROW($A1)>COUNT(y),"",INDIRECT("ª÷ÃB!R"&SMALL(IF(y<>"",ROW(y),""),ROW($A1))&"C",0))
D8°}¦C¤½¦¡
=IF(ROW($A1)>COUNT(y)+6,"",IF(ROW($A1)-COUNT(y)>0,CHOOSE(ROW($A1)-COUNT(y),"","Á`p¥»§å¦@¥æ³f¡G","","¦@ ¥ó","","¦¬³fñ³¹¡G"),INDIRECT("ª÷ÃB!R"&SMALL(IF(y<>"",ROW(y),""),ROW($A1))&"C",0)))
E8°}¦C¤½¦¡
=IF((ROW($A1)-COUNT(y)=1)+(ROW($A1)>COUNT(y)+2),"",IF(ROW(A1)-COUNT(y)=2,COUNT(y)&" ¶µ¥Ø",INDIRECT("ª÷ÃB!R"&SMALL(IF(y<>"",ROW(y),""),ROW($A1))&"C"&MATCH($H$6,ª÷ÃB!$3:$3,0),0)))
*****************************************
F8=IF(B8="","",VLOOKUP(B8,Sheet3!$A$2:$D$100,4,FALSE))
¹s¥ó.rar (55.77 KB)
|
|