Thanks! Not my invention! Credit is to be given this newsgroup for it!
Stefi


€žNigel€� ezt Ã*rta:

Very nice !

--

Regards,
Nigel




"Stefi" wrote in message
...
One method for alerting in case of duplication:
Say your EAN codes are in column A, apply conditional formatting with
formula
=COUNTIF($A:$A,A1)1
for column A with, say red color pattern. Duplicate items will turn to
red!

Regards,
Stefi


€žNigel€� ezt Ã*rta:

The function I provided should work in Excel 97 onwards, I have tested it
in
Excel 2003 and Excel 2007.

Duplication of these numbers or anything else is best dealt with outside
of
this function and any formulaic approach.

The best method depends entirely on the data structure, but I guess you
have
a column of EAN13 numbers and related rows of data you wish to check? To
simply get a unique list use the Advanced Filter option, checking the
option
to copy to another location and click unique records only. Set other
settings to suit your data.

Other methods are possible, if you wish to automate the above, use the
macro
recorder. The resulting code will need to be adapted, especially if you
have
varying lengths of data to manage.


--

Regards,
Nigel




"Donald Eitner" wrote in message
...
Don Quai wrote:
I want to create a function that will allow me to enter in the first
12
numbers of an EAN-13 barcode and have the function calculate the
checksum
and enter it into the appropriate cell. Any ideas?
Dang you folks are quick. Thanks a bunch for the ideas. I just realized
that some extra info might be beneficial to your answering my query. I
am
running Excel 2002. Will these formulas work in this version? Also is
there anyway to modify these formulas so that it will also check for a
duplicate in the worksheet and alert me? I hope you will understand my
question.

Don Eitner