"PL" wrote:
That's really help to capture the duplicate data. thanks! :)

Glad to hear that !

May I know is that another way to do within the same worksheet, for example
sheet x below, to delete the duplicate datas once identified?

I'll presume you mean extract the list of unique lines directly in an area
below in the source sheet: X instead of in a new sheet: Y. Try this construct
in the sample file's sheet X ..

In X,

Assume the source data in cols A to C is expected within row2 to row100 (99
rows)

Put in D110:
=IF(COUNTA(A2:C2)<3,"",IF(SUMPRODUCT((A$2:A2=X!A2) *(B$2:B2=X!B2)*(C$2:C2=X!C2))1,"",ROW()))

Put in A110:
=IF(ROW(A1)COUNT($D$110:$D$208),"",INDEX(A$2:A$10 0,MATCH(SMALL($D$110:$D$208,ROW(A1)),$D$110:$D$208 ,0)))
Copy A110 to C110

Then select A110:D110, fill down by the corresponding 99 rows to D208. The
uniques list will appear within A100:C208, all neatly bunched at the top.
Adapt the ranges to suit the expected extents.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---