Compare cells in cell array to find common columns

I have two cell arrays, data 1 (1x6 cell) and data 2 (1x8 cell) where each cell consists of 3x5 double or 3x4 double. I would like to compare these cell arrays and find out which cells have at least two columns in common, e.g. data1{1,1} and data2{1,1} have two columns in common. Then I would like to store all these cells in a new cell array.

What is the best way to do this?

Answer 1

[Matt J]

You should just use an explicit loop over all combinations of cells. With cell arrays, there is never a good reason to look for some kind of fancy vectorization, and certainly not with arrays as small as what you've posted.

[sr9497]

Thank you for your answer. Which function would you suggest I use to be able to find the common columns if the cell arrays and the cells have different sizes?

[Matt J]

You can transpose the matrices and use intersect(__,'rows') if the agreement between columns is to be exact, otherwise ismembertol(__,'ByRows', true)