How do I return a mileage value from a row and column value

[Guest]

I want to show a list of names, and their distance from a specified point.
By selecting a point from a list I want excel to search a table and return a
list of names of people who are, say, less than 10 miles from the selected
point. The table will contain names in the first column and places in the
first row, with the distances in the table, a bit like a mileage between
table??

 

[Guest]

Hi,

This is a non trivial task ans you need to consider how you calculate
distances, as the crow files (straight line) or transport distances (along
specifi routes).

The straight line is easy as you apply coordinates to the points and it is
simply a matter of math to calculate the distance as you have the start and
end coordinate

You could then have some custom formula in your table that would calculate
the distance and you could then use auto filter to filter the answer.

If it is a transport graph problem then you need to use some graph theoy
procedures or had code the distances in a matrix and use a helper column to
select the required answers.

So once you have decided on the method it is a process of deveoping the sheet.

But first what method are you going to use.

 

[T. Valko]

See if this sample file is what you had in mind:

Distance_lookup.xls 15kb

http://cjoint.com/?bidPlfsoLM

Biff

 

[Guest]

Yes, I think this will help, many thanks.

See if this sample file is what you had in mind:

Distance_lookup.xls 15kb

http://cjoint.com/?bidPlfsoLM

Biff

 

[Guest]

Thanks Martin, it seems a bit more complicated than I had thought. I'll have
another think about the method and re-post. Many thanks again.