Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I return a mileage value from a row and column value
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?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I return a mileage value from a row and column value
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. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "jcb" wrote: 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?? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I return a mileage value from a row and column value
See if this sample file is what you had in mind:
Distance_lookup.xls 15kb http://cjoint.com/?bidPlfsoLM Biff "jcb" wrote in message ... 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?? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I return a mileage value from a row and column value
Yes, I think this will help, many thanks.
"T. Valko" wrote: See if this sample file is what you had in mind: Distance_lookup.xls 15kb http://cjoint.com/?bidPlfsoLM Biff "jcb" wrote in message ... 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?? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I return a mileage value from a row and column value
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. "Martin Fishlock" wrote: 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. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "jcb" wrote: 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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|