You have chosen to sponsor your bid up to a maximum amount of .
I have a small task for excel pro. I have 18 csv files with distances between 1372 geographic objects. I need to filter 15 nearest objects for each object and make one file with different structure. Please see files. The only trick is that results was not duplicated for each object in this files so for example if in calculations for object 1 there is a distance to object 6 so in calculations for object 6 it would be no object 1. That's why I can't just filter the data and find 15 nearest by myself. Need help.