Excel 2007 - Need help with a formula

[johnfn]

Hello,

I need some kind of formula 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 that column A cell.

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

Thanks in advance.

John

 

[VoG]

Try in B1, copied down

=IF(ISNUMBER(MATCH(A1,C:C,0)),"Duplicate","")

 

[martindwilson]

in b1
=if(countif($c$1:$c$100,a1),"duplicate","")

 

[T. Valko]

Hello,

I need some kind of formula 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 that column A cell.

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

Thanks in advance.

John

Enter this formula in column B and copy down as needed.

=ISNUMBER(MATCH(A1,C:C,0))

Duplicates will be marked with TRUE

 

[johnfn]

So far none of these have worked. The content in each of the cells of columns A and C are a paragraph or two of content, if this matters. Could this be why the formulas aren't working?

 

[Shweta]

Hi Johnfn,

Try this in B1

=IF(ISERROR(VLOOKUP(A1,$C:$C,1,0))=TRUE,"","Duplicate")

Hope this will work.

Shweta

 

[johnfn]

Shweta - Still showing no values in column B with the formula you've given.

I just added the data to a google doc if anyone would like to try to help me figure this out: https://docs.google.com/spreadsheet/ccc?key=0AnjaBiG456pidG1ScDFuUnY0UHY1VFZJUmx2cWRhUnc&hl=en_US

 

[VoG]

That looks like everything is in A1 and C1 - is that correct?

Are you actually using Excel or Google Docs?

If Excel, try using Excel Jeanie to post a few rows from your sheet

Link: http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[johnfn]

Everything (or most of everything) in column C should be found somewhere in column A. I am using Excel, I just uploaded it to G-docs for others to see what I'm trying to figure out how to do. I'll download Excel Jeanie and try to post some rows in a few.

 

[johnfn]

Actually the problem I see with trying to add a few lines is that the chances of a duplicate from column C being found in column A is slim since there are 800 cells in column C that are found randomly within 2000+ cells of column A. I don't see how I can post an example.