·s¤â¡A¦³EXCEL°ÝÃD¤@°Ý¡A½Ð±Ð¡A½Ð±Ð
- ©«¤l
- 29
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 35
- ÂI¦W
- 0
- §@·~¨t²Î
- window7
- ³nÅ骩¥»
- 7
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-2-25
- ³Ì«áµn¿ý
- 2021-7-10
![½×¾ÂÃÙ§U¾±³¹ ½×¾ÂÃÙ§U¾±³¹](images/common/medal3.gif)
|
·s¤â¡A¦³EXCEL°ÝÃD¤@°Ý¡A½Ð±Ð¡A½Ð±Ð
²Ä¤@¶:AÄ欰¾û¤u¸¹¡ABÄ欰¾û©m¦W¡ACÄ欰§ó¥÷¡ACÄæ·|¦³©ñ°²¡AA¡AA+3¡AB¡A C¡AC+3§ó¥÷¡A§Ú·Q«Y²Ä¤G¶¤º¸ò¾Ú²Ä¤@¶§ó¥÷¦A¤À¤T³¡¥÷¡A(²Ä¤@³¡)¥÷¬OA¤ÎA+3¤ÎE§ó¡A¤À¾¯Å¡A©m¦W¡A§ó¥÷¡A(²Ä¤G³¡)¥÷¬OB§ó¡A¤À¾¯Å¡A©m¦W¡A§ó¥÷ ; (²Ä¤T³¡)¥÷¬OC¤ÎC+3¤ÎE§ó¡A¤À¾¯Å¡A©m¦W¡A§ó¥÷ ; (²Ä¥|³¡)¥÷¬O©ñ°²RD / OF¡C
§Ú¬OEXCELªìô¡A½ÐÀ°À°¦£¡C
§ó¥÷.rar (13.26 KB)
|
|
|
|
|
|
|
- ©«¤l
- 29
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 35
- ÂI¦W
- 0
- §@·~¨t²Î
- window7
- ³nÅ骩¥»
- 7
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-2-25
- ³Ì«áµn¿ý
- 2021-7-10
![½×¾ÂÃÙ§U¾±³¹ ½×¾ÂÃÙ§U¾±³¹](images/common/medal3.gif)
|
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
![½×¾ÂºaÅA¾±³¹ ½×¾ÂºaÅA¾±³¹](images/common/medal14.gif) ![½×¾ÂÃÙ§U¾±³¹ ½×¾ÂÃÙ§U¾±³¹](images/common/medal3.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif) ![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif)
|
¦^´_ 6# lesaux001
´ú¸Õ«á§â¤£¹ïªº¦a¤è»¡©ú¤@¤U¡A³Ì¦n§ânªºµ²ªG¼Ð¤W¥h¤ñ¸û®e©ö¤ñ¹ï¡C
»¡¹ê¦b§Aªº°ÝÃD§Ú¬O²q¬Ý¬Ý¨Ó°µªº¡C |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 29
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 35
- ÂI¦W
- 0
- §@·~¨t²Î
- window7
- ³nÅ骩¥»
- 7
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-2-25
- ³Ì«áµn¿ý
- 2021-7-10
![½×¾ÂÃÙ§U¾±³¹ ½×¾ÂÃÙ§U¾±³¹](images/common/medal3.gif)
|
ø¦n·N«ä¡A¦hÁÂML089À°§U¡A¦ý§Ú²Ä¤G¶¤º¡A»Ý¤À¶}A§ó / A+3§ó / E§ó¡AB§ó¡AC§ó / C+3§ó¡ARD / OF©ó¤£¦PÄæªí¥Ü! |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
![½×¾ÂºaÅA¾±³¹ ½×¾ÂºaÅA¾±³¹](images/common/medal14.gif) ![½×¾ÂÃÙ§U¾±³¹ ½×¾ÂÃÙ§U¾±³¹](images/common/medal3.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif) ![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif)
|
±µ #4 ¼Ó D6¤½¦¡
A6 =INDEX(OFFSET(§óªí!$B:$B,,MOD(COLUMN()-1,4)),OFFSET($D6,,INT(COLUMN()/4)*4))&""
µM«á½Æ¦Ü¨ì¨C¤@®æ |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
![½×¾ÂºaÅA¾±³¹ ½×¾ÂºaÅA¾±³¹](images/common/medal14.gif) ![½×¾ÂÃÙ§U¾±³¹ ½×¾ÂÃÙ§U¾±³¹](images/common/medal3.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif) ![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif)
|
¦^´_ 1# lesaux001
D6°}¦C¿é¤J¤½¦¡¡A¬° §óªí ªº¦ì¸m
{ =SMALL(IF(ISNUMBER(0/(FIND(§óªí!$D$1:$D$99,LOOKUP(1,0/(A$5:A5="¾û¤u¸¹"),A$3:A3))*FIND(§óªí!$A$1:$A$99,LOOKUP(1,0/(A$5:A5="¾û¤u¸¹"),A$4:A4))*(§óªí!$A$1:$A$99<>""))),ROW($1:$99),4^8),ROW()-LOOKUP(1,0/(A$1:A5="¾û¤u¸¹"),ROW($1:5))) }
¨ä¥LA6¡BB6¡BC6¨Ï¥Î INDEX¨Ó³B²z |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 29
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 35
- ÂI¦W
- 0
- §@·~¨t²Î
- window7
- ³nÅ骩¥»
- 7
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-2-25
- ³Ì«áµn¿ý
- 2021-7-10
![½×¾ÂÃÙ§U¾±³¹ ½×¾ÂÃÙ§U¾±³¹](images/common/medal3.gif)
|
|
|
|
|
|
|
- ©«¤l
- 1374
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1384
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-9-9
![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif)
|
http://blog.xuite.net/hcm19522/twblog/431955212 |
|
|
|
|
|
|