I've just replied to your earlier thread, Ted - look there.

Pete

On Jan 30, 10:34*pm, Farmer Ted
wrote:
I have a formula that is pulling duplicates (thanks to help on this board). *
I was wonedring if Sheet 1 and Sheet 2 have Duplicates can I have data that
is on sheet 1 (in column C1) pulled onto sheet two in the duplicated row?

Formual in Sheet two reads
=IF(ISNA(MATCH(A1,SHEET1!,A:A,0)),"UNIQUE","DUPLIC ATED")

how can I get some data in sheet 1 that corresponds to that Duplicate to
appear in Sheet 2 as well....anyhelp?