0

I have an Excel sheet that works well where I use TEXTJOIN() which is only available in the latest Excel versions. Is there an easy way to transform it to use existing functions of older Excel versions?

My code looks like this:

TEXTJOIN(", ";TRUE;IF(INDIRECT("'"&C5&"'"&"!$E$88:$E$239")="Yes";INDIRECT("'"&C5&"'"&"!$D$88:$D$239");"")
maxmitz
  • 258
  • 1
  • 4
  • 17

1 Answers1

0

Try to combine the formulas IF() and CONCATENATE()

Your Mammy
  • 334
  • 2
  • 10
  • 1
    But how do I do this from E88 to E239. Do I have to check every row? – maxmitz Jul 13 '21 at 08:25
  • 1
    @Theodeo check array formulas [here](https://support.microsoft.com/en-gb/office/guidelines-and-examples-of-array-formulas-7d94a64e-3ff3-4686-9372-ecfd5caa57c7?ui=en-US&rs=en-GB&ad=GB) – Your Mammy Jul 13 '21 at 08:31