求a
=FILTER(B2:G8,A2:A8=I11,"")
先选定几列,然后在第一行去输入函数,再拉取就可以了
标签:-----------------------------------,函数,vlookup,Excel,查询,filter From: https://www.cnblogs.com/cherishthepresent/p/17671361.html
求a
=FILTER(B2:G8,A2:A8=I11,"")
先选定几列,然后在第一行去输入函数,再拉取就可以了
标签:-----------------------------------,函数,vlookup,Excel,查询,filter From: https://www.cnblogs.com/cherishthepresent/p/17671361.html