Google Script / Conditional Formatting to find & highlight duplicate and potential duplicate values.


I am looking for a Google Script to be built with the purpose of finding duplicate values (names) from two lists in two separate columns.

For example;

There will be Column A, and Column B. The script needs to be able to find duplicates values (names) between the two columns. They might not be on the same row - and may differ slightly in spelling.

I need a script / formatting to highlight and extract into a new column all duplicates found.

Let me know if you need any more details!

Many Thanks

Skills: Javascript

See more: google spreadsheet advanced conditional formatting, google answer script, camping google map script, javascript, google maps script buy, google rss script, video google api script, google translation script, add google analytics script, sql google map script, publish google calendar script, google adwords script, google translate script, google blogsearch script, generator google maps script php, google maps script generator, project write, write requirement doc web application, write 250 word newspaper article, write short introduction

About the Employer:
( 7 reviews ) Birmingham, United Kingdom

Project ID: #11757798

Awarded to:


Dear Sir or Ms. I am John, pleased to meet you. I'm well experienced in Google Apps Script and Google Docs. Please, take a look at my portfolio in my profile or here : [login to view URL] Can More

$30 USD in 3 days
(15 Reviews)

6 freelancers are bidding on average $34 for this job


hi, i can create the functionality which will find duplicate values from two separate columns. I can start the work now only.

$10 USD in 1 day
(24 Reviews)

We are team of excellent developers. We have 2 year experience related to your project field. We can do your project and solve your all problems according to your requirements. We have read your description for project More

$45 USD in 1 day
(7 Reviews)

Digi Muflon is a leading software development company providing the highest quality information technology services and solutions at low cost to a broad spectrum of clients. We provide value-added information technolog More

$45 USD in 10 days
(4 Reviews)

Shall we have a discussion.

$50 USD in 1 day
(3 Reviews)

I can do this but , can u please give the list or the database column from whom the duplicate is to be found

$25 USD in 1 day
(0 Reviews)