Thanks that works altough my pc hung a couple of time due to size of file
hence tardy response!
"Max" wrote:

"Space" wrote:
check a list of numbers for duplicate entries in Excel

Assuming source numbers running in A2 down

Put in B2:
=IF(A2="","",IF(COUNTIF($A$2:A2,A2)1,"Dup",""))
Copy down

Col B will flag duplicates in col A as "Dup"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---