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

J

jcb

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??
 
M

Martin Fishlock

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.
 
J

jcb

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top