Käynnissä

Extract data from excel

I will not pay more than $15 to have this done so please don't bid if you can't do it for this price or less.

I have a very large spread sheet of about 3,000 rows with a list of postcodes in 1 column and a list of postcode zones in the other. I need to extract out postcode ranges based on the Zone. Not all the numbers in the postcode zones are consecutive. The output should be in a text file.

For the example below, the output for the DWN range would display like this: DWN~: 0800-0801, 0804, 0810-0813 Consecutive numbers should be seperated with a hyphon and non consecutive numbers with a comma. You should seperate each zone with a pipe symbol.

Each output postal range must be specific to each zone.

Postcode Zone

0200 CBA

0200 CBA

0221 CBA

0800 DWN

0800 DWN

0801 DWN

0804 DWN

0810 DWN

0810 DWN

0810 DWN

0810 DWN

0810 DWN

0810 DWN

0810 DWN

0810 DWN

0811 DWN

0812 DWN

0812 DWN

0813 DWN

I suggest you either do this with VBA or export the info and write a small script

Timeframe:

1 day

Payment:

Escrow on completion (after checking)

Taidot: tietojenkäsittely, Excel, Microsoft Access

Näytä lisää: excel extract data, excel extract, excel data extract, zones, payment processing escrow, less excel, less symbol, excel less, escrow payment processing, vba excel, price excel, postcode, pipe, large data, extract, extract data , excel vba script, excel based, do excel, data checking, cba, extract data excel file, data range, data processing vba, excel specific

About the Employer:
( 36 reviews ) Baulkham H, Australia

Projektin tunnus: #516184

Myönnetty käyttäjälle:

ForeignerKP

Hi, check your PMB please!

30 $ USD 1 päivässä
(2 arvostelua)
2.1

4 freelanceria on tarjonnut keskimäärin 30 $ tähän työhön

SouthIndian

Letz do it. Thanks.

30 $ USD 0 päivässä
(77 arvostelua)
5.3
hdout

hello i may can fill ur desired work,if u help so. thanks

30 $ USD 1 päivässä
(0 arvostelua)
0.0
Vimal20011

Please check the PMB

30 $ USD 1 päivässä
(0 arvostelua)
0.0