Clarification:

Put in B1: =COUNTA(Sheet1!A:A)-A1
B1 returns the # of duplicates

If A1 in Sheet1 contains a col header,

Put instead in B1: =COUNTA(Sheet1!A:A)-A1-1
(subtract "1" for the header)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----