formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2056565%22%20slang%3D%22en-US%22%3Eformula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2056565%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20looking%20for%20help%20on%20a%20formula%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20have%20cells%20A2%26nbsp%3B%20-%20A403%20that%20have%20the%20EXACT%20'numbers'%20in%20them.%20(duplicates)%3C%2FP%3E%3CP%3EThen%20the%20duplicates%20I%20want%20to%20take%20the%20information%20from%20their%20'J%20column'%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20then%20concatenate%20the%20data%20into%20column%20L%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20getting%20stuck%20working%20out%20the%20formula%20please%20advise%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%26nbsp%3B%3C%2FP%3E%3CP%3ELouise%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2056565%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi looking for help on a formula 

 

 

I want to have cells A2  - A403 that have the EXACT 'numbers' in them. (duplicates)

Then the duplicates I want to take the information from their 'J column' 

and then concatenate the data into column L

 

I am getting stuck working out the formula please advise

 

Thank you 

Louise

1 Reply

@louise1111 

In L2 it could be

=LET(colA, $A$2:$A$403, colJ, $J$2:$J$403, TEXTJOIN(", ",1,FILTER(colJ,A2=colA)))

and drag it down