postcodes

Hi Excel geniuses, I'm looking for a macro which will effectively do a VLOOKUP, but where the lookup array is in the macro itself. Basically I have stand alone csv file, the users of which won't have access to a shared folder in which the lookup table can be stored. In one column I have a...

I have a column in a table (called TabPostcodes) with full postcodes and iv'e added a second column where I want to populate with the relevant county based on a separate tables on a different worksheet based on partial postcodes. e.g. I have several postcodes that are in the same county - CH1...

Hi All, This should be a simple one? I'm currently using - =IF(D3="EXC","",LEFT(D3,2)) Column D being a list of postcodes. works fine for most Postcodes, but the single letter ones - i.e Sheffield/S and Birmingham/B it add the number to it, obviously as i'm asking for the 2 characters in the...

Hello, I have a list of postcodes and wish to only count each individual postcode once and not take into account the amount it appears. Any help would be great.

Hello, I understand Excel 2019 has a mapping suite built in, where you can mark maps with postcodes etc. At the moment I have some 1,000 postcodes which I have marked on Google Maps with little pins, these are colour-coded according to strength (for example, if 900 records are in the postcode...

Hi I’ve just registered on this site so apologises in advance if my post is incorrect in any way. I need some help : I have a list of postcodes for a particular county (wanted list) I have another list of random postcodes from lots of different counties (general list) I need to identify how...

I need to calculate the distances between my company head office and a range of customer addresses. Is there a way of doing this in excel perhaps using google maps?. I am in the UK so the distance needs to be calculated between postcodes.

Hi There, I've done quite a bit of researching on ways to extract multiple instances of address where they all have a unique number however I always only get one returned result. My table looks like below (sorry for formatting can't access table maker at present): A Unique Number B Original...

I was provided with this formula by a kind user by the name of jtakw: =IF(ISNUMBER(RIGHT(F2,4)+0),RIGHT(F2,4)+0,"") It separates postcodes in the same cells as city names into their own cells. Some of my records' postcodes also fall within columns E or G. How can I add these so they are...

Hi Folks, I have a simple problem: my INDEX MATCH formula matches 'the first 3 characters RIGHT from the last character' of postcode data in one column; matching it with, any 'postcode data' in another column---this formula returns zone information. I have the following named ranges: Table...

Hi All I'm an OK user of Access (not VBA) and seeking some assistance. I have a query that is working out the distance between postcodes in the UK. I have for example, 16 unique postcodes in one column of data, and another 16 unique postcodes in another column. I was expecting to get 16...

I receive regular spreadsheets that I use for mailouts which need to be sorted by postcode. Unfortunately, the postcodes are usually found in the same cells as other address data, making it impossible to use the codes for sorting: https://imgur.com/a/FgOQ5 I can't use the split to cell...

Hi All I thought this was going to be easy to accomplish but I'm having a lot of trouble with it. I have a long list of postcodes, in the UK postcodes come in quite a few formats but i just want to achieve a simple thing. Postcodes can look like the below: NP12 9AF NP126AF CF32 9PP B1 9AA...

Hi there, I've been given a spread and asked to work out how many times the same postcodes appear within the spread. For example... If I was given the postcodes below, I'd like to have a function to count of how many times they appear... so RH140HW is on there 3 times, RH204NU 2 times, etc.; so...

Can someone please help me with this. I'm at my wits end, I've tried the whole Google API solution with major issues, code was correct but it just seemed to crash when running the macro, could step through it and it worked perfectly. So I think my next avenue of attack is navigating Internet...