How to find vehicles with duplicate VINs

Related Questions

  • How to find vehicles with multiple devices assigned 

Applies To

  • MyGeotab 
  • Vehicle management 
  • VIN 
  • Report 

Procedure

  1. Download an Advanced Device Report 
  2. Use conditional formatting to identify duplicates in the column of VINs 

Additional Notes

To filter out non-duplicate VINs:

  1. Right-click on one of the duplicate cells
  2. Choose Filter
  3. Choose Filter by Selected Cell's Color
  4. This collapses the list to show just the duplicate values

See this external link for how to use conditional formatting in Excel