Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
latitudes and longitudes...
I have this thing with excel, I'm trying to do. I have a long list ( about
6000 entries) for locations along with their latitudes and longitudes. I have these input as text (they are numbers) with no separations. They all however, have the same format, from right to left, first two digits are seconds, next two digits are minutes, and all other digits are degrees. (can be two or three digits) Now what I'm trying to do, is to find some way to sort these guys, or filter them, so that I can see places that are withing say five minutes of a certain set of coordinates. So if for example I have 254935 and 1090006, it would find me everythin within say 254400:255400 and 1089500:1090506. Is this possible? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
latitudes and longitudes...
Maybe Chip Pearson's site can help you on this.
http://www.cpearson.com/excel/latlong.htm Regards, Stefi €žAlex€ť ezt Ă*rta: I have this thing with excel, I'm trying to do. I have a long list ( about 6000 entries) for locations along with their latitudes and longitudes. I have these input as text (they are numbers) with no separations. They all however, have the same format, from right to left, first two digits are seconds, next two digits are minutes, and all other digits are degrees. (can be two or three digits) Now what I'm trying to do, is to find some way to sort these guys, or filter them, so that I can see places that are withing say five minutes of a certain set of coordinates. So if for example I have 254935 and 1090006, it would find me everythin within say 254400:255400 and 1089500:1090506. Is this possible? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
latitudes and longitudes...
=IF(AND(ABS(B2-E$1)<=500,ABS(C2-F$1)<=500),"yes","no")
assuming your lat & long colmns are B and C and that your reference coordinates are in E1 and F1, and also assuming that you do want to be within 5 minutes, rather than the values you've quoted. If you want to round either the list values or the reference values to the nearest minute, you could do that with the ROUND function, or if you want to round up, round down, or truncate, there are functions for those too. -- David Biddulph "Alex" wrote in message ... I have this thing with excel, I'm trying to do. I have a long list ( about 6000 entries) for locations along with their latitudes and longitudes. I have these input as text (they are numbers) with no separations. They all however, have the same format, from right to left, first two digits are seconds, next two digits are minutes, and all other digits are degrees. (can be two or three digits) Now what I'm trying to do, is to find some way to sort these guys, or filter them, so that I can see places that are withing say five minutes of a certain set of coordinates. So if for example I have 254935 and 1090006, it would find me everythin within say 254400:255400 and 1089500:1090506. Is this possible? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting latitudes and longitudes | Excel Worksheet Functions | |||
Convert latitudes and longitudes to decimal | Excel Discussion (Misc queries) |