Trying to use .Find to create a column of values with no duplicates. Code not working.

Hello,
This should be a very simple problem for most I think. I'm just not seeing the problem. So basically I need to sort thru the data on columns A:B on Tester and pick out the unique part numbers and their cost and then check column C to see if the part number exists there, if it does not, then add it to column C along with the cost in column D. But for some reason, while the first 2 part numbers seem to work fine, it then starts adding duplicates to column C and I'm at my wits end to figure out why my code is allowing this to happen. Any help is greatly appreciated.

Please Login or Register  to view this content.

Thank you so much! That fixed it.

How about

Please Login or Register  to view this content.

Thanks for that & the Rep