VBA to identify and eliminate duplicate cells

I have a spreadsheet containing many thousands of rows extracted from a  document management database. Each row has multiple columns. Across those colimns for each row, some cells may contain duplicate data. E.g. 

A1 = “legal”

B1 = “legal”

C1 = “Warranty”

D1 = “warranty”

E1= “warranty”

F1 = “guarantee”

G1=”legal”

The  vba code would need to identify in the row the duplicate values and delete cell (shift left), so the result would be

A1 = ‘legal’

B1 = “warranty”

C1 =”guarantee

Not all rows would contain duplicate cells and the duplicates will not occur in the same position in each row. The VBA would be reiterative for however many rows may exist.

By: Diane

297 thoughts on “VBA to identify and eliminate duplicate cells

  1. coronavirus cats fip

    middle east respiratory syndrome coronavirus , dates respiratory syndrome coronavirus entered each country – treatment for coronavirus puppies : saudi arabia response to the middle east respiratory syndrome coronavirus .

Comments are closed.