Filter data, Deleting Duplicate Rows with vba,

Hi,

My challenge is to remove duplicate rows based on column value.

On column B, there is a list of software name. On column C, there is a list of computers.

Please find attached a sample.

For invoicing purpose, latest version of software should be kept.

Ex: For Workstation 11673, I have

- Adobe Acrobat XI Pro
- Microsoft Project Standard 2013
- Microsoft Office Project Standard 2010
- Microsoft Project Standard 2010.

As Microsoft Project Standard 2013 is the latest (Microsoft Office Project Standard 2010 & Microsoft Project Standard 2010 should be removed based on duplicate)

Please Login or Register  to view this content.

Wrong rows are deleted

Any help would be highly appreciated.