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.
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.