SOLVED

Textjoin if by column

Occasional Contributor

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!

15 Replies

@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

 

 

@eechols 

And what is on Sheet B?

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.

@eechols 

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

@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

looks like mine is 365 business with version 15.0.5459.1000
Filter won't work?
I tried this; =textjoin(",",,IF(June!G5:G72>June!F5:F72,June!C5:C72,"")) but the error is #NAME?

@eechols 

Is that Mac or Windows? Build number looks quite old.

@eechols 

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.

@Sergei Baklan 

working, I think. Looking like this.

eechols_0-1659117743466.png

 

Windows. Is this old??

eechols_1-1659117776540.png

 

 

Actually, when I hit enter for the textjoin cell, it gave me an #NAME error. So I think this software is too old...too bad.
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.
best response confirmed by eechols (Occasional Contributor)
Solution

@eechols 

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

THANK YOU SO MUCH!!! It finally worked! But thank you everyone for all the help!!!

@eechols 

I see, TEXTJOIN() is not available in your version of Excel. Why don't to upgrade?