Sounds good to me.
Why not dist=SQRT(delta-x^2+delta-y^2)
Suppose you have the table in A1:I10 (city names in top row and left column)
Then =MAX(B2:D10) will locate the largest distance
In B12, this formula =MAX(B2:B10) gives the max of first column
Copy this to I12
Now we need in B13, =MATCH(MAX(B12:I12),B12:I12,0)
This tells us the column in which the larges values lies
In C13 use =CHOOSE(B13+1,"A","B","C","D","E","F","G","H","I") &2
In D13 use =CHOOSE(B13+1,"A","B","C","D","E","F","G","H","I") &10
These give results like D2 and D12 (when the D column has the largest value)
In E13 use =MATCH(MAX(B12:D12),INDIRECT(C13&":"&D13),0)
Finally:=INDEX(A2:A10,B13) and =INDEX(B1:I1,E13-1) give the two city names
Let me know what mark we get for the homework
By the way his name was Pythagoras
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"aneudul" wrote in message
ups.com...
Hi everyone here,
Normally I'd keep thinking for a solution by myself, but I've
recognized my own limitations.

This is my (your) challenge: (I'll use a imaginary case, to make my
point clear)
I got a list of, let's say, cities and their location; this is, x-y
coordinates.
I need to know which city is the most remote from its most neighboring
city; kind of: biggest minimum distance.

I know Pitagoras to calculate the distance:
if city A x=5 y=8
and city B x=1 y=3
then distance AB= ( deltax ^2 + deltay ^2 ) ^0.5
in this case AB= (4^2+5^2)^0.5 = 6.403

So, I need to know the biggest distance between EACH cell in the list
and the other ones ...
I suspect that I need to make a two-dimensional cross-table, with the
same list as column headers and row headers? (sorry about my english,
I have a Dutch version of the software).
Am I searching in the right direction?

I would appreciate any help, since I need to resolve this issue very
soon.

Thanks in advance!

Marcos