shown a way to calculate distances between 2 points

so loop through each record and calculate the distance for the location of
that record and the radius origin. If it is less than the radius value,
then it is within the radius. (again, repeat for each record).

--
Regards,
Tom Ogilvy


"marinusw" wrote in message
...
That's for the info. That was very helpful.

The second part of the problem for me is the radius search. Seeing as how
you've shown a way to calculate distances between 2 points, and I now
have
the data points, I assume there must be a way that if I entered the radius
origin and radius value that I could find all records withing that radius.
But how to do that is beyond me. Any help?

Thanks all!
----------------------

"Gary''s Student" wrote:

see:

http://www.cpearson.com/excel/latlong.htm


--
Gary's Student
gsnu200702


"marinusw" wrote:

I have a series of records based on latitude & longitude coordinates
(with
some other associated data attached) which I got in a .txt file. I
imported
it all into Excel.

First question: How do I format the cells for latitude & longitude in
degree, minutes, and seconds? Right now the records imported into
seperate
d-m-s columns.

Second question: Now that I have the data, I'd like to be able to do a
search to find which records fall within a specific radius.

Can this be done in Excel? How? If not, can anyone recommend another
inexpensive application?

Thanks for the help.