【函中201301班】练习题2-indirect()练习

雨后的风

1. =INDIRECT(TEXT(MOD(ROW(),3),"[=2]R"&6+INT(ROW()/3)&"C"&COLUMN(A1)&";[=1]R7C"&COLUMN(A1)&";R5C5"),)&""

复制代码

1. =INDIRECT(TEXT(TEXT(MOD(ROW(),3),"[=2]"&(6+INT(ROW()/3))*10+COLUMN(A1)&";[=1]"&70+COLUMN(A1)&";95"),"R0C0"),)&""

复制代码

1. =INDIRECT(TEXT(MOD(ROW(),3),"[=2]!"&LOOKUP(COLUMN(A1),{1,"A";2,"B";3,"C";4,"D"})&6+INT(ROW()/3)&";[=1]!"&LOOKUP(COLUMN(A1),{1,"A";2,"B";3,"C";4,"D"})&"7;!E5"))&""

复制代码

1. =IFERROR(INDIRECT(IF(MOD(ROW(),3)=2,LOOKUP(COLUMN(A1),{1,"A";2,"B";3,"C";4,"D"})&6+INT(ROW()/3),IF(MOD(ROW(),3),LOOKUP(COLUMN(A1),{1,"A";2,"B";3,"C";4,"D"})&7))),"")

复制代码

yjeeee

1. =IF(MOD(ROW(),3)=1,A$7,IF($K6="姓名",INDIRECT(CHOOSE(COLUMN(A1),"a","b","c","d")&COUNTIF($K$6:K6,"姓名")+7),""))

复制代码

C07:yjeeee  请老师点评！

wangjianff

wangjianff 发表于 2013-4-15 22:44
=INDIRECT("R"&MATCH($F8,$A:$A,0)&"C"&MATCH(G7,$A$7:$D$7,0),)
=INDIRECT(CHAR(64+MATCH(G7,$A$7:$D$7,0 ...

哦 呵呵 谢谢老师指点 理解错误 以为标题栏是给的 只需要得出成绩就行 现已改正
=IFERROR(INDIRECT("R"&CHOOSE(MOD(ROW($A1)-1,3)+1,7,CEILING(ROW($A21)/3,1))&"C"&COLUMN(A$1),),"")
=IFERROR(INDIRECT(CHAR(64+COLUMN(A$1))&CHOOSE(MOD(ROW($A1)-1,3)+1,7,CEILING(ROW($A21)/3,1))),"")

wangjianff

哦 呵呵 谢谢老师指点 理解错误 以为标题栏是给的 只需要得出成绩就行 现已改正
=IFERROR(INDIRECT("R"&CHOOSE(MOD(ROW($A1)-1,3)+1,7,CEILING(ROW($A21)/3,1))&"C"&COLUMN(A$1),),"")
=IFERROR(INDIRECT(CHAR(64+COLUMN(A$1))&CHOOSE(MOD(ROW($A1)-1,3)+1,7,CEILING(ROW($A21)/3,1))),"")

岁月静好

都不会，真要好好学习了

007feiren

没做上来，前来学习。

我不知道呀

学习一下！

漫天独舞

学习下                                                                        

pang1688

dddddddddddddddd

fcyxiaoyuer

走过路过瞧一瞧看一看