distance between points to matrix form..

Originally Posted by Richard Buttrey

Hi,

The attached is one solution. Just double check the master formula for brackets and precedence in J2 on the Points in Block sheet.

Regards

Richard, thanx for that, it isnt exactly what I was looking for though, its great how the size of that grid changes but the formula doesnt calculated what i need....
The h values isnt the points 1, 2, 3, 4. The h value is the distance between teh point 1 and 2..So for 1, 2 in this example 1: x = 60, y = 87, 2: x = 105, y = 87. So the distance between them would be SQRT((X1-X2)^2+(Y1-Y2)^2): h = sqrt((60-87)^2+(105-87)^2) which would give h = 45 m...I then need this h value in the equation to find gh.....Does this make any sense???
I have show what the 4 point matrix should look like, so that it might be easier to understand... I have shown the h values, then the gh values in two different tables, though I do need only the gh values in the major table....Thank you so much for all the help!!