Pulling an column/row Data from one sheet- another if critria is m

  • Thread starter Thread starter Farmer Ted
  • Start date Start date
F

Farmer Ted

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","DUPLICATED")

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