Need help figuring out a formula or macro [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

I need some kind of formula or macro that can do the following:

If the exact value of a cell in column C is found anywhere in column A, then the word "duplicate" needs to be added in column B next to the value that was found to be a duplicate from the cell in column C.

A summary of my problem is basically I have content 800 cells of duplicate content in column C, that is within 2400 cells of column A. I need to remove the rows of duplicates from column A.

Thanks in advance.

John

3 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
798
the data from A1 is like this

name data
a a
s d
d g
f j
g w
h e
j r
k t
l

in C2 type ( copy) this formula

=IF(COUNTIF(A2:A100,B2)=1,"duplicate","")
copy c2 down

you will get

name data
a a duplicate
s d duplicate
d g duplicate
f j duplicate
g w
h e
j r
k t
l


provision made for 100 data in column A
Not exactly what I'm looking for. Let me try to explain it again. If a cell in column C if found anywhere in column A, then "duplicate" must be written in column B next to the cell of column A where the duplicate cell was found.
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
798
the logic remains the same

can you simply put the formula in B2 with words B2 changed to C2 Try on your own and it will be a pleasure to modify a formula given by another person. if there is problem post back

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!