(NEW WORKBOOK) Compare duplicate values data and remove non compliant

Hello and thank you all for your help,

I have a spreadsheet that contains many columns and rows.

On this sheet I have in the left most active column a list of Formula names that have more than one record due to the Additives that are associated with the Formula name.(Normally there will be many Formula names some will not have multiple records, I just filtered those out to make it a bit easier to comprehend, I can return them if necessary)

What I would like the code to do is, find the duplicate Formula names and then compare the data in each of the rows that pertains to that Formula name, and if all the values in the rows are not the same, I need to remove the cell values that are not present in all the rows pertaining to that Formula name.

and then loop down the sheet and do the same for each record that has duplicate Formula names.

Thanks again, I attached the spreadsheet.

This Workbook has been updated, further on in the thread.

Hi lanziniad
It would be helpful if you would add a second sheet to your sample file that demonstrates what your results will look like. I could guess but it would be just that.

jaslake,

Thank you for your reply, im sending the updated WB right now, sheet 2 shows the results of what the code should do.

dangelor,

I tried it, but it deleted way to much, here are the results, Sheet 2 shows what it should have looked like.

Hi lanziniad
I, for one, can't make any sense of your logic. You have two items for Formula 30M1 (in Column C); Column K for these two items are different (3152 and 30M1) yet you're keeping 30M1 and discarding 3152. This doesn't fly with this

I need to remove the cell values that are not present in all the rows pertaining to that Formula name.

Same is true for Formula 3492 except that two of the items are the same and one is different yet, you're keeping two and discarding one. Columns L & M are even more confusing. I believe further explanation is required.

Hi lanziniad
I've a massive head cold, a touch of the Flu, a head and ears that ache and a throat that's raw from hacking the last three days and can't get into see the Doc until tomorrow. So, I have no wish to try to think through your logic. Please see attached and explain what you're looking at and how your decisions are made. Of course, you could wait until I feel better...I may be willing to pay more attention to it then...but...probably not. You've not explained it well (in my opinion).

jaslake,

Here is my best explaination that I can think of, and it address the questions that you asked in sheet 2.

Hi lanziniad
I can think of an approach to do as you describe. How many records are we talking about, including these?

there will be many Formula names some will not have multiple records

How many Formula names WILL have multiple records?

The reason I ask is that the approach I'm considering will involve A LOT of looping. Of course, if this is a one time shot then it may not matter how long it takes (within reason).

Ok I have reconfigured my spreadsheet, hopefully this will be less confusing.
What I need is to find Duplicate Values on Row 2 starting at Column C and then for each set of Duplicates compare their columns and remove any values that are not all their columns.