Extracting Common Values from Text Strings

An Excel file that teaches how to perform Extracting Common Values from Text Strings operation.

Excel Extracting Common Values From Text Strings

Comma-separated text strings are kept in List1 and List2 columns. Within the LET structure, each string is divided into list elements with TEXTSPLIT, and the common elements in the two lists are determined with the combination of MATCH and ISNUMBER. The FILTER function creates the common array by filtering only the common values, while TEXTJOIN turns this array into a single text separated by commas. The ROWS function calculates the number of common items and displays them in the Count column.

Hope it is useful.