Import excel, Compare Vectors, and output results including strings
1 view (last 30 days)
I'm trying to import two excel spreadsheets (attached) then compare the "Amount" column on Expenses.xlsx to Total_Fee, Fee1, and Fee2 on database.xlsx.
Finally, I would like to output all the values (including the corresponding strings) that are missing from columns Total_Fee, Fee1, and Fee2.
For example, the output would be
I'm having trouble reading the excel file with [num,txt,raw] = xlsread(_). I'm getting a lot of NaN values. I was thinking of using something like out = Amount(ismember(Amount,[Total_Fee;Fee1;Fee2]) == 0) to help me do the comparison and output but I'm now sure what syntax to use to tell it what columns to look it.