Skip to main content
2 of 2
replaced http://gis.stackexchange.com/ with https://gis.stackexchange.com/

If the IDs are consecutive, I would add a new temporary column with unique values like @Ship.shp suggested and then use the query builder to search for ID != uniqueID.

That would return the duplicates directly. After fixing the original IDs, remove the extra column or repeat the whole process as needed — it is not clear what kind of pattern your IDs must match. If they just need to be unique, note the last value first and you can then edit the bad IDs in one iteration, just bumping the number as you go.

lynxlynxlynx
  • 4.3k
  • 3
  • 31
  • 46