Howdy Renate,

I had sent it directly.

cat file1 file2 |sort |uniq -d > duplicate_barcodes

For Windows users for whom an emulation layer such as VirtualBox or Cygwin
is overkill and who encounter issues implementing Gnuwin, there are two
options:

1) Windows 10: Enable linux subsystem (it's a Windows feature that's off by
default -- all you have to do is turn it on)

2) All versions: Download native win32 ports of the utilities. Installation
consists of dumping the executables in a directory. Be sure to add this
directory to the front of your path so these programs are triggered before
dos/windows utilities with the same names.

Disclaimer -- I haven't tested any of this so I leave it to other to point
out any errors in logic. Since Kyle mentioned problems with the cat
command, the "type" command will can be considered equivalent at a windows
command prompt

Let me know if you have any questions.

kyle


On Wed, Nov 22, 2017 at 8:18 AM, Renate Morgenstern <[log in to unmask]>
wrote:

> Good day,I could not see the suggested solution by Kyle Bannerjee with
> the cat command.  Possibly he sent it to you directly?If you still have
> it please forward it to me.ThanksRenate Morgenstern
> > Thanks, everyone, for taking the time to reply to my question!  I
> > liked the
> > simplicity of Kyle Bannerjee's command line suggestion, but stumbled
> > over
> > how to get the "cat" command to work on my Windows machine and
> > couldn't
> > figure out how to properly implement GnuWin32, so I went with a
> > variation
> > of Hannah's solution, using this formula in Excel:
> >
> > =IF(COUNTIF($C:$C, $A2)=0, "No", "Match!")
> >
> > On Fri, Nov 10, 2017 at 4:16 PM, Kyle Breneman <[log in to unmask]
> > om>
> > 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
> > >
> --
>
>
>
>
>
>
>
>
>
>
> Renate Morgenstern
>
> Tel.: +264 61 242124
>
> Cell: +264 81 2910284
>
> Fax: 088637518
>
> Windhoek, Namibia
>