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.

I would like to bring Column A names in a cell (textjoin) of those with their Column B numbers bigger than their Column C numbers besides them on sheet B. Is this possible?

Thank you so much!

excel
Formulas and Functions
    • 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
        MVP
        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

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jul 29, 2022

    eechols Let's say the names and numbers are in A1:C5, then this formula will do just that:

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

    ..... provided I understood correctly 🙂

     

     

Resources