Hi Guys, I know I'm a newbie but is there anyone out there who can help me? I used some code from another thread to create all the possible combinations of points and am working off of that, but I feel like there is an easier way.
I have attached my spreadsheet as a reference.
I was wondering if there is a way to keep a stationary (x1, y1) and loop through all of the (x2, y2) values, then move onto the next (x1, y1) and loop through all of the (x2, y2) values until I am done with all of my (x1, y1) points. This is mostly like a taxicab geometry problem but I am having an issue finding a simple way to loop with out changing my (x1, y1) values by hand.
My goal is to find the combination that gives me the 3 smallest sums overall. All sums would need to be stored on another spreadsheet I assume but I would need to be able to reference which combination of points gave me my smallest sums. RioRancoDemand.xlsx![]()
Bookmarks