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

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pulling from one sheet to another 3
Pulling data from one sheet to another 2
Matching column in different sheet 1
Pull value from another sheet 3
Moving data from one sheet to another 5
sumif only seeing one row 3
Get information from one sheet to another 2
moving answer from one sheet to another 1

Top