postal

Hi, I have a list of postal codes arranged on 1 column of around 13000 rows. Some of these postal codes could be collapsed and setup in ranges since they are consecutive like in the example below: 121012 and 121013 could be collapsed in 1 row as Low:121012 High:121013 <tbody> Country IATA...

<tbody> Province Postal Code Shipping Net Ontario M4M 1L4 $3 Ontario M4M 1X5 -1 Ontario M4M 3Z7 -50 BC Y3L 1Z4 -30 BC Y3L 1X5 -300 BC Y3L 1M9 -700 </tbody> I have about 200K rows of transactions, to a whole set of postal codes. I'm...

Hi, I'm from Canada & I'm trying to see if there is a formula or macros I can use to calculate the distance between two postal codes for Excel 2007. A1 - Postal Code 1 B1 - Postal Code 2 C1 - Distance Any help would be greatly appreciated. Thanks, Laurinda

Hi, I'm from Canada & I'm trying to see if there is a formula or macros I can use to calculate the distance (KM) between two postal codes. A1 - Postal Code 1 B1 - Postal Code 1 C1 - Distance (KM) Any help would be greatly appreciated. Thanks, Laurinda

Hi, Hope you can help, I've spent hours trying to figure this out! :-) I have a group students and their addresses with a postal code in one set of data. I'm trying to match them to get work experience at one of our stores based on proximity of location. BUT the students addresses wont exactly...

I need to test a postal code in one sheet to a range of codes in another sheet and return the data in a specified cell. EG: Client's postal code is 0001, test against the Postal Code ranges in col A and return the relevant Province in col B. <colgroup><col...

Hello, I have a list of cities with distances and travel times between them. Postal Code is only for further identification of the city or city part. The table looks like this (with a total of 60000 rows): <tbody> Postal Code 1 City 1 Postal Code 2 City 2 Distance(km) Travel time(minutes)...

Hello, How do I filter or extract cells with address and postal codes only. In a large excel sheet, there are cells with address and postal codes. (All in one cell througout the sheet) Is there a way to say: look in the cell and if it has a postal code in it, copy the entire cell (Including...

Hi All, Need a help in capturing data from another spreadsheet. I have two files 1. File A (1200 rows) <tbody> Name Exchange City Address1 Address2 State Country Postal Abe John CBOT New York Mark Twain CME Singapore </tbody> 2. File B ( 300 rows) <tbody> Address1 Address2...

Dear Excel experts, I want to design a mechanism for my postal addresses management I have sheet in which I have write address like this <tbody> <tbody> Sr. # Consignee Name Consignee Address Consingee Contact Number Sender Sender Name Sender number 1 Mr. Muzzafar Iqbal Sun Crop...

This seems as an easy task, but unfortunately I can't figure out an easy fix. I have a data set with rows representing different answers to our poll. Some of the rows contain the same postal code. Now I am trying to draw 3D map from the data set and Excel understandably combines all the points...