Hi there,
What exactly is it that you are meaning on saying match the two columns?
- Comparing each row element in one with each row element in another?
- Comparing corresponding row elements?
- Comparing columns of different size?
If you doing xlsread and taking the raw data, then you can do something like this to do a corresponding element-wise comparison:
Case - Check if both columns same
[~, ~, raw1] = xlsread('data1.xlsx');
Destination1 = {raw1{:, 1}}; % column 1
[~, ~, raw2] = xlsread('data2.xlsx');
Destination2 = {raw2{:, 1}}; % column 1
isequal(Destination1, Destination2);
You can also check ismember function
Thanks
Nikhil
