Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding state that contains employees biggest sale | Excel Discussion (Misc queries) | |||
zip code to city, state function | Excel Worksheet Functions | |||
Finding a name with biggest number | Excel Worksheet Functions | |||
Would u help me with a Biggest Movers type of comparison? | Excel Discussion (Misc queries) | |||
WHATS AN EASY FUNCTION TO USE TO ROUND TO THE NEAREST THOUSAND? | Excel Worksheet Functions |