Logic function to combine all matching text into one cell

Asked Oct 18 '18 at 22:05

Active Oct 18 '18 at 22:09

Viewed 36 times

I am looking for help with a formula that looks for all matching text and combines the results into a single cell. For example if the Country is Colombia I want a single cell to list all of the names that match Colombia.

    ColA        ColB
A1: COUNTRY     NAME
A2: Argentina   John Doe
A3: Bahamas     Jan Doe
A4: Colombia    James Doe
A5: Colombia    Jason Doe
A6: Colombia    Julian Doe

I've toyed around with CONCANTENATE and MATCH however they don't seem to be getting me what I need.

edited Oct 18 '18 at 22:09

Tim Williams

154,628
8
97
125

asked Oct 18 '18 at 22:05

Bernard Jenkins

What version of Excel? – Tim Williams Oct 18 '18 at 22:12
2

possible duplicate of [TEXTJOIN for xl2010/xl2013 with criteria](https://stackoverflow.com/questions/50716550/textjoin-for-xl2010-xl2013-with-criteria/50719050?s=1|83.3296#50719050) – Oct 18 '18 at 22:31
Great outcome! Thanks! – Bernard Jenkins Nov 03 '18 at 16:40

Logic function to combine all matching text into one cell

0 Answers0