unique values in cell array

I have a cell array with both numerical values and strings

test1 = {1,2,3,'No';1,3,2,'Yes';2,2,2,'Yes'}

I need to find the unique values of each column, regardless of the data type. Anyone know how to do this? Thanks.

Answer 1

[Wayne King]

You could do this:

test1 = {1,2,3,'No';1,3,2,'Yes';2,2,2,'Yes'};
out = unique(cellfun(@num2str,test1,'uni',0));

and then convert the strings with numbers back to numbers.