Hi,
I'm trying to generate an array that has XYZ coordinates for the columns and rows. I've successfully generated a formula to calculate the distance between each point. But what I cannot do is drag this formula to other columns or rows without having to edit it each time. The default adjustment to the formula makes it draw data from completely incorrect columns/rows. There being several hundred columns and rows, I would prefer not to edit it almost 10000 times. Any comments, tips would be greatly appreciated.
-Sam
Bookmarks