If statement or strcmp to compare names.
2 views (last 30 days)
Show older comments
Hi everyone,
I have two excel sheets, the first one has three columns names, score and extra activities. The second column has only one column with names.
I want to compare the two sheets and if the names matches then I want to add 10 points to the score. I would really appreciate any help. I uploaded the data and below is my code so far.
Data = readtable("Data.xlsx")
Data2 = readtable("Data2.xlsx")
Volunteer_Names = ismember(Data.Extra_activities,'Volunteer Work and Community Service');
Volunteer_Names = Data(Volunteer_Names,:)
Add_Points = strcmp(Data.Names,Data2.Names,:)
0 Comments
Accepted Answer
Walter Roberson
on 21 Jul 2021
ismember(). If you only want to know if at least one matches then any() the results; if you want to know how many matched then nnz() the ismember() result
More Answers (0)
See Also
Categories
Find more on Structures in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!