ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¤S¬O§Ú¡A¨D§U¡AÀ°§U¡A¤S¬OEXCEL°ÝÃD!

¤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)

IMAG0438.jpg (223 KB)

IMAG0438.jpg

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),"")

TOP

hcm19522¡A§Ú«D±`¦hÁ§A¡AÁ`ºâ¸Ñ¨M¤F¤u§@¤W°ÝÃD¡AÁÂÁÂ!

TOP

·Q°Ý°Ý{   }·N«ä¬O¤°»ò?

TOP

¦^´_ 4# lesaux001

"{" ¥Nªí shift+ctrl+enter ¤TÁä¤@°_«ö©Ò²£¥Í ,«Dµ{¦¡¸Ì­±

TOP

hcm19522¤j¤jªº¤½¦¡¬O­n¶K¦b­þ¸Ì¤~¯à¥Îªü?@@ ¤£·|¥Î

TOP

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¤½¦¡

TOP

        ÀR«ä¦Û¦b : °µ¦n¨Æ¤£¯à¤Ö§Ú¤@¤H¡A°µÃa¨Æ¤£¯à¦h§Ú¤@¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD