Question

How do you remove duplicate entries in 2 different columns?

By nancyvinci92 ·
Tags: Google, Software
Okay, here's what the problem is.

I have 2 columns with a number of URLs.
I need a function to highlight duplicate items in both columns so I can identify and superimpose the data.

The major issue is that there are nearly 20000 items in both rows :9

And I forgot to mention, I'm using Google Sheets.

Note: I figured out how to do this in a row using conditional formatting and the =countif(A:A,A1)>1 function, but how do I do it for two columns, let's say - A and G.
3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

I tried

by nancyvinci92 In reply to How do you remove duplica ...

Does this add-on work?

I tried this and failed. https://developers.google.com/apps-script/articles/removing_duplicates

Collapse -

Ignore above post

by nancyvinci92 In reply to How do you remove duplica ...
Collapse -

Ignore above post

by nancyvinci92 In reply to How do you remove duplica ...
Back to Windows Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums