Forum Discussion

eechols's avatar
eechols
Copper Contributor
Jul 29, 2022
Solved

Textjoin if by column

Hi,  I am new to this community and I don't even know if it's possible, but I would like a textjoin if formula for my work spreadsheets. On sheet A, I have column A with names, B and C with numbers...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jul 29, 2022

    eechols 

    See if the attached demo does what you want. It should work in all versions of Excel.

  • eechols's avatar
    eechols
    Copper Contributor
    Jul 29, 2022
    I am making a summary sheet on Sheet B. Sheet A has all the actual data. Somehow =TEXTJOIN(",",,FILTER(A1:A5,B1:B5>C1:C5)) gave me an error message of invalid function.
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jul 29, 2022

      eechols 

      As variant

      =TEXTJOIN( ", ", ,IF( B1:B5 > C1:C5, A1:A5, "" ) )

      If not Excel 365 or 2021 it shall be entered as array one with Ctrl+Shift+Enter

      • eechols's avatar
        eechols
        Copper Contributor
        Jul 29, 2022
        I tried this; =textjoin(",",,IF(June!G5:G72>June!F5:F72,June!C5:C72,"")) but the error is #NAME?
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jul 29, 2022

      eechols 

      Most probably you don't have FILTER. On which Excel version / platform you are?

      • eechols's avatar
        eechols
        Copper Contributor
        Jul 29, 2022
        looks like mine is 365 business with version 15.0.5459.1000
        Filter won't work?

Resources