https://community.esri.com/t5/arcgis-pro-questions/remove-duplicate-rows-based-on-unique-id-and/m-p/1670858#M100636 <P>Figured it out. Used Summary Statistics</P><P>For the statistics field I used the distance with the Minimum Statistics and the Case Field set to the Asset Number unique identifier</P> Fri, 05 Dec 2025 14:41:27 GMT GaryBarden 2025-12-05T14:41:27Z https://community.esri.com/t5/arcgis-pro-questions/remove-duplicate-rows-based-on-unique-id-and/m-p/1670843#M100632 <P>I have a point feature layer that contains duplicate records for proximity to similar features. I want to find the rows for each point that has the shortest distance. I tried sorting based on attribute and distance and then used the Delete Identical Tool, hoping that it would leave the first row and remove that rest, but it seems like it just randomly leaves one of the rows and removes the rest. I've attached a screenshot of the table below.</P><P>Thanks</P> Fri, 05 Dec 2025 13:45:02 GMT https://community.esri.com/t5/arcgis-pro-questions/remove-duplicate-rows-based-on-unique-id-and/m-p/1670843#M100632 GaryBarden 2025-12-05T13:45:02Z https://community.esri.com/t5/arcgis-pro-questions/remove-duplicate-rows-based-on-unique-id-and/m-p/1670858#M100636 <P>Figured it out. Used Summary Statistics</P><P>For the statistics field I used the distance with the Minimum Statistics and the Case Field set to the Asset Number unique identifier</P> Fri, 05 Dec 2025 14:41:27 GMT https://community.esri.com/t5/arcgis-pro-questions/remove-duplicate-rows-based-on-unique-id-and/m-p/1670858#M100636 GaryBarden 2025-12-05T14:41:27Z https://community.esri.com/t5/arcgis-pro-questions/remove-duplicate-rows-based-on-unique-id-and/m-p/1670905#M100644 <P>Nice! thanks for sharing your solution.</P> Fri, 05 Dec 2025 16:57:09 GMT https://community.esri.com/t5/arcgis-pro-questions/remove-duplicate-rows-based-on-unique-id-and/m-p/1670905#M100644 AyanPalit 2025-12-05T16:57:09Z