post code

  1. C

    Post Code as Geography Data Type - 37 out of 88 not recognised

    Hi, as the title says really. I have a data set of 88 postcodes. They are local schools, so well established buildings in well established areas. I need to plot these on a map in Power BI, so I've gone to Data toolbar in Excel and clicked on Geography. Out of the 88 postcodes, 51 of them have...
  2. N

    Post does not appear

    Hi,Today morning I create a new thread and post my problem with the VBA code.But unfortunately it does not appear in MrExcel forum and also when I checked my latest post option it displays me an old post.And I tried to post it a several times.How do I solve this?
  3. K

    Using Excel to map locations and distances between instances

    Hi, I have a population of businesses whose post code I know. What I want is an Excel calculation that will show me the number of other businesses within say 40 square miles of their Post Code? I can get the post codes and convert them to longitude and lattitude coordinates but I dont know how...
    • kdamax
    • Thread
    • distance distances location post post code
    • Replies: 2
    • Forum: Excel Questions
  4. L

    Remove all Non UK or incorrectly formatted postcodes from column

    Hi, I have a sheet that has postcodes from all over the globe not to mention some really bad data entry, what I need to do is remove these leaving only the correctly formatted UK post codes. I have tried and looked every where for a macro, formula or conditional formatting trick but with not...
    • Lorr81
    • Thread
    • data cleaning. formula macro post code validation
    • Replies: 14
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top