I have a large Workbook with 3 Columns.

Example:
Computer Name ProdName Version
AA746437 Flash Player ActiveX 10.3.183.10
AA746437 Flash Player Plugin 11.4.402.265
AA746437 Flash Player Plugin 10.3.183.10
AA746437 Flash Player ActiveX 11.4.402.265
AA746437 Acrobat Reader 9.5.2.295
AA746437 Acrobat 9.4.6.252 Standard
AA746437 Acrobat Distiller 9.4.0.195
AA746437 Acrobat Reader 9.5.2.295

I need either a VLookup function or VBA Script to give me the rows that have for each Computer Name with a Duplicate ProdName and Duplicate Version to either Highlight that line or give me a list of those records/rows only.

Hope that is enough info for an answer.

Thanks in advance for any assistance.

Steven Higgins