Stuart’s MATLAB Videos

Watch and Learn

Making a MATLAB Script to Compare Two Long Lists of Strings from Excel

I often need to compare long lists of strings, usually URLs. If I have less than a few thousand, and the data is already in Excel, I will use the MATCH and INDEX functions in Excel to do this. However, if the lists are in the order of tens of thousands or hundreds of thousands, Excel struggles. Here, I write a very simple MATLAB script to input two lists of strings from Excel spreadsheets, compare using setdiff, and intersect and write the results back.

This video uses the code-along style.

Play the video in full screen mode for a better viewing experience.

  • print
  • send email


To leave a comment, please click here to sign in to your MathWorks Account or create a new one.