geography

Hi, I am trying to find the distance between zip codes in separate columns in a work book. To do that I need to convert a full column of text zip codes into the geography data type. The problem is that my dataset is large, 300k+ rows, and Excel cannot handle converting the entire column at...

Hello, For the sentence: "A map is a visual representation . The work of a map is to illustrate geography." I know that the formula "=RIGHT(B2,LEN(B2)-FIND(" ",B2))" will remove the first letter in the string. Leaving "map is a visual representation . The work of a map is to illustrate...

Because the heading is so clear! I have the following data: <tbody> A B C D E F H I J K UPN Name Year SEN Care FSM Subject Type Class Points 123 abc 7 S Y Y Geography Homework 7L4/Gg 1 456 def 7 Technology Homework 7L4/Te 1 678 ghi 8 S Y Science Disruption to Learning 8a/Sc3 2...

I know I am missing something really basic here and would be grateful if someone could point out to me what. If the values in certain subjects are greater than or equal to 4 then I want the formula to return "Y" else "N". The formula I am using is...

I'm not really sure how to explain this... basically I get reports on student grades for tests/projects on different dates. THe report that's generated can export to excel but it's not the easiest to work with. I'd like to make a macro to convert this data to a different format (Like student...

Hi Folks, Can you please help me with the below query: Master Data: <colgroup><col><col span="2"></colgroup><tbody> Username Subject Score A1 English 50 A1 Maths 45 A1 Physics 34 A1 History 23 A1 Geography 56 A2 English 24 A2 Maths 67 A2 Physics 45 A2 History 32 A3...

Any idea how to do this? You have LAT1, LON1, LAT2, LON2 and you want to calculate: A: distance B: bearing (initial bearing along a great circle ie the shortest distance) C: bearing along rhumb lines ("constant bearing") For example if you want to go from 0, 0 to 0, 90E, the answer to C would...