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.
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 🙂