Em Andamento

Info entered into same format as before

These instructions are on the ss, the info is on both tabs- format 1&2.

format 1 Instructions

copy name of estate agent to number of branches,

paste -special transpose

for each copy(not cut) postcode into postcode column,

delete any info after the actual postcode (in both the address and postcode fields)

type in number of branches into 'no of branch' column

if no branch info leave blank.

for residential info to average listing info-

I am trying to end up with the all this info in one cell as in W3

the way I have done it is to copy and transpose info into D3, used the formula in T3 and then copied as value into W3

(probably an easier way to do this)

format 2

Instructions

copy name of estate agent- if there is a location after the name leave in but take out 'logo'

copy and paste address

for each copy(not cut) postcode into postcode column,

delete any info after the actual postcode (in both the address and postcode fields)

copy the actual telephone number into contact no sometimes there is other info apart from the no. only include the number

Habilidades: Processamento de Dados, Extração de Dados, Excel, Captura de dados na web, Busca na Web

Ver mais: transpose, name format, before after, address name format, type documentation format often used discipline criminal justice, format cell, residential telephone, residential telephone number, residential number, excel macro concatenate formula number cell, telephone agent, residential address, copy paste number listing, checking money format entered dollars cents java, cell location info, lead type used salesforcecom, copy cut paste delete, type domains formula, imei info phone type, formula logo, cut paste info, logo paste cut, crystal report format formula, shp type format

Acerca do Empregador:
( 2 comentários ) Coventry, United Kingdom

ID do Projeto: #6794471

Premiar a:

bpwebanalysts

Hired by the Employer

£50 GBP em 2 dias
(103 Avaliações)
6.4