Another problem is not all of the latitudes are in that format sadly as can be seen by this example cell: The red highlighted information is what is valuable to me. Keep the cells that have latitudes and longitudes and get rid of the rest. Search and Rescue 30NM S MARTHA'S VINEYARD 40-37.4N 070-43.3W MEDEVAC OF 35YOM EĪs such the problem I am having is figuring out how to search through the cells for ones that have a lat and long in them since there is other information and numbers in the comment cell. ![]() ![]() I used some VBA to sort out all the ones that have zeroes in the lat and long columns because I noticed in a comments block some of them have the latitude and longitude placed in the comments instead of the designated spot.Īn example of one of the comment cells is this: ![]() Some of the data I was given has latitudes and longitudes which are valuable to me but some of the information was entered incorrectly and the lat and long columns have only zeroes for some entries. Good Afternoon, I am currently working on a project and need some help data mining a extract from a database that's in excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |