Need to compare two excel and extract the mismatch data
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
I have excel Conatant_Sheet1 in that I have two coloumns like signal name and the conatant value.
I have excel 2 name Constant_sheet2 in that again the same data but count is mismatched.
Suppose if in sheet1 we have 10 conatants then there will be 8 conatnts in sheet2 I need to comapre these names along with the values and extarct the names of the signals which are having the differences.
I have attached two sample excel sheets here. Expected results will be like the mismatched data
as Conatant You is added in the sheet2 and value of conatant Barak_obama is chnaged so this is again one mismatch
I want this two misamtched signal names along with their values in the output( whereever in new excel or in matlab variable ..any possible ways)
Mismatched data :
Barak_Obama 4
You 5
Thanks in Advance .... !!!!
3 Kommentare
Alex Mcaulley
am 9 Mär. 2020
setxor could be another option. As @darova says show us your code and your specific issues to obtain better answers
Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!