0

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. enter image description here

And my formulas: PlayerNames:

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

Players:

=COUNTIF(teamRecs,B4)

Signed:

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

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

Pᴇʜ
  • 56,719
  • 10
  • 49
  • 73
Hightower
  • 968
  • 4
  • 24
  • 58
  • 2
    Just a shot in the dark as I don't have `TEXTJOIN` but something along these lines possibly? `{=TEXTJOIN(", ",TRUE,IF(I4:I13=1, IF(J4:J13="y",H4:H13,""),""))}` Notice to enter as array formula. – JvdV May 02 '19 at 07:24
  • Formula looks OK but looking at your formula B4 must be A4 – EvR May 02 '19 at 07:35
  • 1
    @jvdv answer was spot on. Thanks. If you make it an answer, I'll flag it. Only thing missing is the else "" for the second IF. Thx – Hightower May 02 '19 at 22:10

1 Answers1

1

As per comment, you could try:

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

Enter as array through CtrlShiftEnter

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

JvdV
  • 70,606
  • 8
  • 39
  • 70