Remove Duplicate rows based on Unique ID and Distance

[GaryBarden]

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.

Thanks

[GaryBarden · Accepted solution]

Figured it out. Used Summary Statistics

For the statistics field I used the distance with the Minimum Statistics and the Case Field set to the Asset Number unique identifier

[AyanPalit]

Nice! thanks for sharing your solution.