Help needed !!!

R

Rakesh Khowal

Hi ,
Wishing all group members a Happy Dipawali !!
I am grappling with this problem for quite some time. I hope your
ideas can give some insights. I have one address column due to
ignorance of the guy who input the data. He mistakenly input it the
way it was there in the questionnaire. I need to sort it in the best
possible manner so that I can have a clear cut view that can help me
do a door to door selling of product. I can accordingly pull the data
of a particular area and visit a every household in that locality. I
have about 50 K entries to sort. Manual sort would take weeks to do
it. I have put few of the address entries below. Thanks a lot.

C/O RAM RAO B-5 LOCAL SHOPPING CENTRE INDUSTRIAL AREA PHASE II
WZ 555 H NARAINA VILLAGE
WZ-139B 2ND FLOOR NARANAG VILLAGE WOODS ROAD
B 2 MOUNT EVEREST CGHS PLOT-NO-17 SECTOR 9 DWARKA
FLAT-NO-406 EIL APARTMENT PLOT-NO-13 POCKET 6 DWARKA PHASE-1 NASIRPUR
C/O M L SOOD C-48 CHANDER NAGAR JANAKPURI
106 ANSAL IMPERIAL TOWER C-BLOCK COMMUNITY CENTRE NARAINA VIHAR
 
M

Matthew Dyer

Hi ,
Wishing all group members a Happy Dipawali !!
I am grappling with this problem for quite some time. I hope your
ideas can give some insights. I have one address column due to
ignorance of the guy who input the data. He mistakenly input it the
way it was there in the questionnaire. I need to sort it in the best
possible manner so that I can have a clear cut view that can help me
do a door to door selling of product. I can accordingly pull the data
of a particular area and visit a every household in that locality. I
have about 50 K entries to sort. Manual sort would take weeks to do
it.  I have put few of the address entries below. Thanks  a lot.

C/O RAM RAO B-5 LOCAL SHOPPING CENTRE  INDUSTRIAL AREA PHASE II
WZ 555 H NARAINA VILLAGE
WZ-139B 2ND FLOOR NARANAG VILLAGE WOODS ROAD
B 2 MOUNT EVEREST CGHS PLOT-NO-17 SECTOR 9 DWARKA
FLAT-NO-406 EIL APARTMENT PLOT-NO-13 POCKET 6 DWARKA PHASE-1 NASIRPUR
C/O M L SOOD C-48 CHANDER NAGAR JANAKPURI
106 ANSAL IMPERIAL TOWER C-BLOCK COMMUNITY CENTRE NARAINA VIHAR
Click to expand...

Since I'm not entirely sure how the addresses in your country read, I
will propose my solution as if it were US addresses.

Example with a United States address:
(Address Number) (Street name), (City), (State), (Zip Code)
(123) (N. Central St), (Phoenix), (AZ) (85027)

For US addresses I'd try to seperate the zip code using a macro or
some sort of function, then sort data by zip code to get all addresses
in the same area.

Now it doesnt look like your addresses have any zip-codes included.
Could you somehow group them by city or township?
 
R

Rakesh Khowal

Since I'm not entirely sure how the addresses in your country read, I
will propose my solution as if it were US addresses.

Example with a United States address:
(Address Number) (Street name), (City), (State), (Zip Code)
(123) (N. Central St), (Phoenix), (AZ) (85027)

For US addresses I'd try to seperate the zip code using a macro or
some sort of function, then sort data by zip code to get all addresses
in the same area.

Now it doesnt look like your addresses have any zip-codes included.
Could you somehow group them by city or township?
Click to expand...

Thought to do the way you suggested, but here sometimes town are not
positional plus some people have misspelled it. Wish it were like
address in the US; It would have been done by now...
 
Top