different excel file comparisons

Hello, I have two excel files,
First excel file as shown below
and second excel file as shown below.
I want to compare these excel files values but ı have a problem. As you seen in the first column the order of the names are not same. How can I compare these two excel file among the same names.I will print the results on the adjacent column after the comparison.

Answers (1)

T1 = readtable(file1) ;
T2 = readtable(file2) ;
idx = ismember(T1.names, T2.names)

1 Comment

Thank you. I also want to compare their values by sorting the names.

Sign in to comment.

Categories

Products

Asked:

on 19 Apr 2021

Commented:

on 19 Apr 2021

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!