So i have been manually using =Concatenate(??,",",??) to get the output i need but doing that on a lot of rows is exhausting. So long story short i have two columns AA has URLs in it and AB has the model numbers in it. I need it to return all the matching urls in one cell separated by commas. Like this. Is there an easier way?
It will not let me copy and past because im a new user and it has more than 2 url’s so here is a file.
Help.ods (29.5 KB)
I don’t sure to understand in detail your question.
E2 =IF(AND(B2<>C2;C1<>C2);TEXTJOIN(",";1;B2:B4);"")
and copy down.
its a bit tricky… E2 ⇒
{=IF(D1<>D2;TEXTJOIN(",";1;OFFSET(B2;0;0;MIN(IF(D2:D$100<>D3:D$101;ROW(D$1:D$100);""));1);"");"")}
ask_103756.ods (25.6 KB)
it is partially working here is the full file. It quits working around line 191
ask_103756_partial.ods (516.1 KB)
Obviously you should adjust the »endpoints« in the formula:
=IF(D1<>D2;TEXTJOIN(",";1;OFFSET(B2;0;0;MIN(IF(D2:D$1954<>D3:D$1955;ROW(D$1:D$1954);""));1);"");"")
ask_103756_adjustet_up_to_row_1954.ods (561.1 KB)
Sorry still learning