Forum Discussion
Find Duplicates with Specific Codes
Hello, I have a list of terms (also duplicates) in column A and specific codes for each term in column B. Now, I want to make a list contains unique terms and those codes which belong to the terms, ...
That could be
=TEXTJOIN(", ",TRUE, IF(A:A=E2,B:B,""))Depends on which Excel you are it could be entered as regular formula or with Ctrl+Shift+Enter. Please check in attached.
And from performance point of view it's better to use reference not on entire columns but on range.