need help with a formula to sort closest values to a static value of both X and Y. For instance, static (X)227:(Y)559 entire sheet goes from X 200-299 and Y 500-599. Getting the near values are easy but as the radius grows it gets to hard to determine which points are closest to the Static Value. I need it to prioritize it from closest to farthest, i know some values/distances will be the same, thats ok. I need it to just sort by both X and y and create a new sheet in priority order. (Scatter plot still to hard to work with.)
Any help would be appreciated.
Comments
Post a Comment