- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 255
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-25
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-4-13 22:27 ½s¿è
¦^´_ 11# jj369963
16854¬O¦]¬°§Aì¨Óªº¸ê®Æ¥u¨ìA16854
Yn¸Ñ¨M¸ê®Æ¶qÅÜ°Ê¥i¼W¥[¤@Ó§PÂ_¸ê®Æ§Àªº¦WºÙ
©w¸q¦WºÙ®É§@¥ÎÀx¦s®æªº¦ì¸m·|¼vÅT¨ì¬Û¹ï°Ñ·ÓªºÄæ¦C¦ì
©Ò¥Hn¯S§Oª`·N©Ò¦bÀx¦s®æ¦ì¸m
h¦WºÙ(¨ú±oì©l¸ê®ÆªºAÄæ¸ê®Æ§À)
=LOOKUP("ùÕ",ì©l¸ê®Æ!$A$2:$A$65536,ROW(ì©l¸ê®Æ!$2:$65536))
rng_1¦WºÙ(¨ú±oì©l¸ê®Æ½d³ò)
=INDIRECT("ì©l¸ê®Æ!A1:A"&h)
s¦WºÙ(pºâì©l¸ê®Æ!AÄ椺¦³´XÓ¥N¸¹)
=SUMPRODUCT(ISNUMBER(FIND("a. Dependent Variable: ",rng_1))*1)
*********
¿ï¨ú¥N¤½¦¡!B1(¦]¬°¦WºÙtn±qBÄæ¦V¥k±q1¶}©l»¼¼W¡A©Ò¥HSMALLªº²Ä2¤Þ¼Æ¨Ï¥ÎCOLUMN(¥N¤½¦¡!A$1)³òÄæ¬Û¹ï¡B¦Cµ´¹ï°Ñ·Ó¡A¬G§@¥ÎÀx¦s®æ¥²¶·¦ì©óBÄæ)
t¦WºÙ(¨ú±o²Ä´XÓ¥N½X©Ò¦b¦ì¸m)
=SMALL(IF(ISNUMBER(FIND("a. Dependent Variable: ",rng_1)),ROW(rng_1),""),COLUMN(¥N¤½¦¡!A$1))
x¦WºÙ(¥N½X¸ê®Æµ²§ôÂI)
=MATCH("a. Dependent Variable: "&¥N¤½¦¡!B$1,ì©l¸ê®Æ!$A:$A,0)
y¦WºÙ(¥N½X¸ê®Æ°_ÂI)
=MATCH("b. Dependent Variable: "&¥N¤½¦¡!B$1,ì©l¸ê®Æ!$A:$A,0)
k¦WºÙ(¥N½X½d³ò¦Cz)
=x-y+1
rng¦WºÙ(¥N½X¹ê»Ú¸ê®Æ½d³ò)
=OFFSET(ì©l¸ê®Æ!$A$1,y+4,1,k-6,3)
******************
¥N¤½¦¡!B2¤½¦¡
=SUMIF(INDEX(rng,,1),$A2,INDEX(rng,,2)) |
|