"PaulQuincy" wrote:
I tried what you said but i ended up with a sheet 2 not showing anything
at all. Maybe I did something wrong, I'll try again a couple times.
To make it easier you can assume that all the data is in column A only
(the data is only in a single column)

My apologies, Paul ..
the earlier criteria formula (col E in Sheet2) was incorrect

Put in E1:
=IF(Sheet1!D1="","",IF(COUNTIF(Sheet1!$D$1:D1,Shee t1!D1)1,ROW(),""))

should have read as:

Put in E1:
=IF(Sheet1!D1="","",IF(COUNTIF(Sheet1!$D$1:D1,Shee t1!D1)1,"",ROW()))

[ No change to the other formulas ]

(The earlier criteria formula flagged the *duplicates* in col D in Sheet1,
instead of the *uniques*)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---