I have 9 columns of text data and need to know the common terms that are found in all nine columns (or possibly different combinations of columns). I can do 2 columns `=IF(ISERROR(MATCH(A1,$C$1:$C$133,0)),"",A1)` and I can find the text values that are duplicates across the whole spreadsheet but can't figure out how to look at the common text values across multiple different columns.

Is there a way to modify the `=IF(ISERROR(MATCH(A1,$C$1:$C$133,0)),"",A1)` formula so I can compare 3, 4,... 9 columns rather than just two? I'm using Microsoft 2013 if that helps.