If they’re strings and you’re a *nix user I’d export them to files, sort them and use the comm command to generate a list of common values. On Fri, Nov 10, 2017 at 16:17 Kyle Breneman <[log in to unmask]> wrote: > I have 2 Excel files, each with a column of barcodes. I am supposed to > determine which, if any, of the barcodes in the first file are also present > in the second file. Is writing a short Python program the best way to do > this, or is there a more efficient way? (There are about 300 items in the > first file and about 1,000 items in the second file.) > > Regards, > Kyle > -- Rogan Hamby Data and Project Analyst Equinox Open Library Initiative phone: 1-877-OPEN-ILS (673-6457) email: [log in to unmask] web: http://EquinoxInitiative.org