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