¤S¬O§Ú¡A¨D§U¡AÀ°§U¡A¤S¬OEXCEL°ÝÃD!
- ©«¤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

|
¤S¬O§Ú¡A¨D§U¡AÀ°§U¡A¤S¬OEXCEL°ÝÃD!
¤S¬O§Ú¡A¨D§U¡AÀ°§U¡A¤S¬OEXCEL°ÝÃD! §Ú¤w¥[¤J[attach]24679[/attach]¹Ï¤ù¤Îªþ¥ó¡A¦n§Æ±æ¦U¦ì¯à©ú¥Õºç¤¤¤º®e¡AÁÂÁÂ![attach]24680[/attach]
EG.rar (8.9 KB)
|
|
|
|
|
|
|
- ©«¤l
- 1399
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1409
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2025-2-20

|
D6:Z15{=IFERROR(OFFSET($A$1,SMALL(IF($A$2:$A$18=TRIM(LEFT(SUBSTITUTE(T(OFFSET($D$3,,INT(COLUMN(A1)/4)*4))," ",REPT(" ",9)),9)),ROW($A$2:$A$18)),ROW(A1))-1,MOD(COLUMN(A1),4)-1),"") |
|
|
|
|
|
|
- ©«¤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

|
hcm19522¡A§Ú«D±`¦hÁ§A¡AÁ`ºâ¸Ñ¨M¤F¤u§@¤W°ÝÃD¡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

|
|
|
|
|
|
|
- ©«¤l
- 1399
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1409
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2025-2-20

|
¦^´_ 4# lesaux001
"{" ¥Nªí shift+ctrl+enter ¤TÁä¤@°_«ö©Ò²£¥Í ,«Dµ{¦¡¸Ì± |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- WIN7
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-7-11
- ³Ì«áµn¿ý
- 2016-12-2

|
hcm19522¤j¤jªº¤½¦¡¬On¶K¦bþ¸Ì¤~¯à¥Îªü?@@ ¤£·|¥Î |
|
|
|
|
|
|
- ©«¤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
     
|
D6:F6 =T(INDEX($A:$C,SMALL(IF($A$2:$A$18=TRIM(LEFT(D$3,4)),ROW($2:$18),4^8),ROW(A1)),{1,2,3}))
°}¦C¿é¤J(CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡¡A¤½¦¡·|Åܦ¨ {.....})
D6:F6¤U©Ô½Æ»s
D6:F15 ½Æ»s¦Ü¨ä¥L¦ì¸m
EG_ML089.rar (11.98 KB)
|
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|