Forum Discussion
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...
See if the attached demo does what you want. It should work in all versions of Excel.
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.
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
- I tried this; =textjoin(",",,IF(June!G5:G72>June!F5:F72,June!C5:C72,"")) but the error is #NAME?
Hard to say without the file. You may use curvy quotes instead of "normal" ones, whatever.
Try to open attached file if formula works in your environment.
- Do I have any ways to have the same result without using filter or textjoin? I don't have to have them all in one cell like textjoin but they can be a list in a column.