Is there a way to use Excel to help identify like numbers
from two differnt lists of numbers. These lists of
numbers contain numbers that are numeric and alpha-
numeric.

With conditional formatting and a formula,

Say list 1 is in A1:A1000, list 2 in H1:H5000

Select A1:A1000, and add a CF formula of =COUNTIF($H$1:$H$5000,A1)0

and then H1:H5000, and add a CF formula of =COUNTIF($A$1:$A$1000,H1)0=

--

HTH

RP
(remove nothere from the email address if mailing direct)


"dan s" wrote in message
...
Is there a way to use Excel to help identify like numbers
from two differnt lists of numbers. These lists of
numbers contain numbers that are numeric and alpha-
numeric.