(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.