One interp and formulas play (Try in a copy of your sheet) ..

Cut n paste sequentially (one below the other) the data that's in cols B to
F into col A, so that all data is in col A

Then place

In B1:
=IF(A1="","",IF(COUNTIF($A$1:A1,A1)1,"",ROW()))

In C1:
=IF(A1="","",IF(COUNTIF($A$1:A1,A1)1,ROW(),""))

In D1:
=IF(ROW()COUNT(B:B),"",INDEX($A:$A,SMALL(B:B,ROW( ))))

Copy D1 to E1. Select B1:E1, copy down to last row of data in col A. Col D
returns the list of unique part#s, col E returns the list of duplicate part#s
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"ace21" wrote:
I have six columns of part numbers (A-F) that I want to compare to each
other. The part numbers that are an exact match I want displayed in column G
and the number that do not match I want displayed in column H. What is the
best way to accomplish this with an Excel fomula?