提取的不准确，原因？

grldrkjhuy · 发表于 2021-4-20 08:41

本帖最后由 grldrkjhuy 于 2021-4-20 09:22 编辑

选择A1，从所有的表中提取数据到新表sheet1中，公式套用后数据不准确？请大侠修改重新上传了文件

grldrkjhuy · 发表于 2021-4-20 10:07

=INDIRECT(INDEX({"吉林大学","北京理工","复旦","天津大学","厦门大学","华中科技","西安交大","北京师范","同济","北京航空","中国科技大学","人大","南京大学","浙大","中山大学","武汉大学","清华","北大","南开大学","上海交大"},--LEFT(TEXT(SMALL(IF(T(OFFSET(INDIRECT({"吉林大学","北京理工","复旦","天津大学","厦门大学","华中科技","西安交大","北京师范","同济","北京航空","中国科技大学","人大","南京大学","浙大","中山大学","武汉大学","清华","北大","南开大学","上海交大"}&"!C$1"),ROW($1:$60),))=$A$1,COLUMN($A:$T)/1%%+ROW($2:$60),10^10),ROW(A1)),"000000"),2))&"!r"&RIGHT(SMALL(IF(T(OFFSET(INDIRECT({"吉林大学","北京理工","复旦","天津大学","厦门大学","华中科技","西安交大","北京师范","同济","北京航空","中国科技大学","人大","南京大学","浙大","中山大学","武汉大学","清华","北大","南开大学","上海交大"}&"!C$1"),ROW($1:$60),))=$A$1,COLUMN($A:$T)/1%%+ROW($2:$60),10^10),ROW(A1)),4)&"C"&COLUMN(A1),)

谢谢大家，已经解决

cinlo · 发表于 2021-4-20 10:19

为啥不把学校列表放到一行或者一列呢？

		自动登录	找回密码
密码			免费注册

[已解决] 提取的不准确，原因？