英文:
Combine Two Filter Functions in Excel
问题
Column A 中有一些数据,我通过公式 =FILTER(A1:A27,A1:A27<>"")
在列 E 中看到相同的数据。类似地,列 C 中有一些数据,我看到 =FILTER(C1:C27,C1: C27 <> "")
出现在 f 中。现在,如果我想通过公式查找列 A 和 C 的列 G,该如何在公式中解决呢?
注意:列 B 和 D 中的数据不会影响结果。
在 Excel 中合并两个筛选函数
英文:
Column A has some data which I see in column E by formula =FILTER(A1:A27,A1:A27<>"")
Similarly column C has some data which I see =FILTER(C1:C27,C1: C27 <> "")
appears in f. Now if I want to look up column G through a formula for both columns A & C, how to solve it in a formula?
Note: The data in columns B and D will not affect the results
Combine Two Filter Functions in Excel
答案1
得分: 2
如上所述在评论中,并且 OP 也确认了,它对他们有效,因此将其发布为答案。
对于所说的帖子,可以使用以下公式:
=VSTACK(TOCOL(A1:A27,1),TOCOL(C1:C27,1))
或者,
=TOCOL((A1:A27,C1:C27),1)
另外,如果您想从返回的数组中获取唯一值,那么可以将数组包装在 UNIQUE()
函数中。
英文:
As mentioned above in comments and as OP also confirmed, it worked for them, hence posting it as answer.
For the said post, formula can be used :
=VSTACK(TOCOL(A1:A27,1),TOCOL(C1:C27,1))
Or,
=TOCOL((A1:A27,C1:C27),1)
Also if you are looking to get Unique values from the returned array then you can wrap the array within an UNIQUE()
function.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论