将Excel TextJoin与具有多个条件的Countifs()结合使用 [英] Using Excel TextJoin in conjunction with a Countifs() with multiple criteria

问题描述

我想返回一个逗号分隔的字符串列表，该列表基于两个表中的匹配，但带有条件条件.

I would like to return a comma separated list of strings, based on a match within two tables, BUT with a conditional criteria.

下面您将明白我的意思.

Below you will see what I mean.

我的公式: 玩家名称:

And my formulas: PlayerNames:

{=TEXTJOIN(", ",TRUE,IF(B4=teamRecs,playerNames,""))}

玩家:

=COUNTIF(teamRecs,B4)

签名:

=COUNTIFS(teamRecs,B4,K4:K13,"y")

我的问题是，我想返回玩家名称列表，仅在已签名的情况下. -在Excel中可以吗?

My Issue is that I would like to return the list of PlayerNames, only if they have been signed. -- Is this possible in Excel?

推荐答案

根据评论，您可以尝试:

As per comment, you could try:

{=TEXTJOIN(", ",TRUE,IF(I4:I13=1, IF(J4:J13="y",H4:H13,""),""))}

通过 Ctrl Shift Enter

可惜我没有TEXTJOIN自己来测试它，即使我有Excel 2016:(

Shame I don't have TEXTJOIN myself to test it, even though I have Excel 2016 :(

这篇关于将Excel TextJoin与具有多个条件的Countifs()结合使用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！