- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 239
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-4
|
¦^´_ 9# jj369963
¿ï¨ú¥N¤½¦¡!C1·s¼W
©w¸q¦WºÙt
=SMALL(IF(ISNUMBER(FIND("a. Dependent Variable: ",ì©l¸ê®Æ!$A$1:$A$16854)),ROW(¥N¤½¦¡!$1:$16854),""),COLUMN(¥N¤½¦¡!A$1))
©w¸q¦WºÙs
=SUMPRODUCT(ISNUMBER(FIND("a. Dependent Variable: ",ì©l¸ê®Æ!$A$1:$A$16854))*1)
©w¸q¦WºÙx
=MATCH("a. Dependent Variable: "&¥N¤½¦¡!C$1,ì©l¸ê®Æ!$A:$A,0)
©w¸q¦WºÙy
=MATCH("b. Dependent Variable: "&¥N¤½¦¡!C$1,ì©l¸ê®Æ!$A:$A,0)
©w¸q¦WºÙk
=x-y+1
©w¸q¦WºÙrng
=OFFSET(ì©l¸ê®Æ!$A$1,y+4,1,k-6,3)
******¥H¤U¬°¤½¦¡******
¥N¤½¦¡!C1¤½¦¡
=IF(COLUMN(A$1)>s,"",SUBSTITUTE(INDIRECT("ì©l¸ê®Æ!A"&t),"a. Dependent Variable: ",""))
¦V¥k½Æ»s
¥N¤½¦¡!C2¤½¦¡
=SUMIF(INDEX(rng,,1),$B2,INDEX(rng,,2))
¦V¥k¦V¤U½Æ»s
«D¼Ð·Ç¤Æ!D4¤½¦¡
=IF(ISERROR(MATCH($C4,¥N¤½¦¡!$1:$1,0)),"",INDEX(¥N¤½¦¡!$A$1:$AI$91,MATCH(«D¼Ð·Ç¤Æ!D$2,¥N¤½¦¡!$B:$B,0),MATCH($C4,¥N¤½¦¡!$1:$1,0)))
¦V¥k¦V¤U½Æ»s
example0412-1§ó·s.zip (1.9 MB)
|
|