Delete duplications in row not column

[stroudy]

Hope someone can help, I'm trying to work out a macro or some code that will delete duplicate entries in the row not column.

example:

Cell A Cell B Cell C Cell D
1 YU2 ABH YU2 ABH YU2 ABH YU2 ABH
2 abc 123 yorkshire boston abc123
3 blean kent york dge 098
4

I want for instance cell D to retain the post code entry and the other entries to delete if they contain the same post code, else leave entry if value is different.

Hope you can help. Thanks

[Leith Ross]

Hello stroudy,

Welcome to the Fourm!

There seems to be something missing. In the workbook there are only 3 columns while in your example there are 4 columns. I am guessing the workbook is correct. Can you advise me on which is correct?

[stroudy]

Hello stroudy,

Welcome to the Fourm!

There seems to be something missing. In the workbook there are only 3 columns while in your example there are 4 columns. I am guessing the workbook is correct. Can you advise me on which is correct?

Thanks The workbook is fine.

[Leith Ross]

Hello stroudy,

Just to be sure I understand, you want to delete any row that has a duplicate postcode, correct?

[stroudy]

No sorry I need it to be the cell or cells not rows

sorry I'll do a better example


CELL A CELL B CELL C
1AS FJX CVF T56 CFR 67J < this row is fine.
ASB FGH ASB FGH ASB FGH <Delete cell A AND B on this row not cell c
123 456 ADS FGH 123 456 <Only delete cell A on this row.

[stroudy]

Please check example spreadsheet

[stroudy]

Hi I need a code which will delete duplicates in cells in the same row.

See attachment. thanks

[Leith Ross]

Hello stroudy,

The macro below has been added to a button in the attached workbook. This will remove the duplicates in columns "A" and "B".

Please Login or Register  to view this content.

[stroudy]

Hi Thanks very much for this,

The macro works great but it only deletes the cells if they both are the same as the country. My fault due to explanation. I also need A2 =123 to delete as this matches country criteria.
Thanks

[Leith Ross]

Hello stroudy,

Please take your time and provide a sample workbook that accurately reflects the data and the layout. Include examples of the data showing both before and after results. This will ensure that you are provided with a complete and accurate solution.