kingdom

Hi all, I am trying to create a Map Chart with English Regions and/or local authorities. I think the latter is impossible, but the former two should be possible. I think my issue might be something to do with my labelling of the data? The regions of England are...

Hi Guys, I would like to change excel function to VBA Code. Here is the excel function,=IF(AND(ISERROR(FIND(" ",E3))),IF(LEN(E3)<3,E3&"?"&$F$1&E3&"??",E3&"*"),IF(LEN(E3)>3,SUBSTITUTE(E3," ","")&"*"&$F$1&$E$1&E3&$E$1,SUBSTITUTE(E3," ","")&"?"&$F$1&SUBSTITUTE(E3," ","")&"??"&$F$1&$E$1&E3&$E$1))...

Hi In column "L" I have a list of cities/countries: Toronto, Ont., Canada Montreal, Que., Canada Toronto, Ont., Canada Manchester, England, United Kingdom New York City, New York, United States Frankfurt, Germany Abuja, Nigeria Frankfurt, Germany Manchester, England, United Kingdom Doha, Qatar...

Hello, I'm looking to inquire about how to return a country's cost, based on a given weight. The issue is that the weights I'm looking up against have predesignated weight breaks, the given weights ('B' below) may fall between the range. I'm ultimately looking to return the rounded up value...

Hi, I have thousands of records of longitude/latitude pairs in excel and would like to compare them against shapefiles to identify what area (United Kingdom local authorities) they sit in. This is where the United Kingdom area perimiters are defined...