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,""))}
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?
As per comment, you could try:
Enter as array through CtrlShiftEnter
Shame I don't have
TEXTJOIN
myself to test it, even though I have Excel 2016 :(