excel formula

The goals is de-dup based on any header selected but preserve selective dedup data into the remaining unique record.

For this example we will choose the first field which is Group_Legal_Business_Name and search list of uniqueness. I also want to change formula to use phone number or other field for uniquness if required.

If Dups – Servicing County name field should be appended to the primary record separated by a “;”


212 Chiropractor LL would be de dup and have servicing county filed updated to include include: Venango;Crawford;Mercer;Forest;Clarion;Warren. These are from the duplicate listings. The same should also apply to specialty column and phone no.. phone for example: 3308562112;3308562111

There should be no repeated names in the Servicing County for each row or specialty.

All duplicates will be flagged

Skills: Excel, Data Entry, Data Processing, Visual Basic

See more: call web service excel formula, excel formula sheet, microsoft excel formula sheet, check excel formula aspnet, excel formula convert utm latitude, excel formula network address range, excel formula capture data time day, accounting excel formula, excel formula expertise, excel formula doc file, excel formula escrow, excel formula aging report accounting, excel formula creator, excel formula call sheet, simple excel formula required

About the Employer:
( 0 reviews ) Dunwoody, United States

Project ID: #20919000

Awarded to:


( ͡ᵔ ͜ʖ ͡ᵔ ) Hello, sir! I am happy to put my bid on your project. I have a full of experience with data processing using Excel formula and VBA. Here are projects I have done recently using Excel VBA and formulas. ==== More

$25 USD in 1 day
(15 Reviews)

5 freelancers are bidding on average $22 for this job


Hello! let me help you. Just award the project to me and I will take care of the rest. I offer high quality and accurate output. Hope you will consider me, thanks.

$25 USD in 7 days
(26 Reviews)
$25 USD in 1 day
(0 Reviews)

I have read your project description. I have lots of experience on this sector. I think I can do this project in your budget range within your expected time perfectly. Please Discuss with me for once before you give th More

$15 USD in 7 days
(0 Reviews)

Hello, How are you? As a senior software developer, I am good at Excel (VBA & Macro). I can start to work on this task right now and complete it perfectly. Look forward to hearing from you. Thanks,

$20 USD in 1 day
(0 Reviews)