I need to find duplicate entries in a workbook. Without going into a very
long and boring explanation as to why the dates are in with the headings and
other odd setup practices Ill just say that I have to use other peoples
data.
Here is the formula that I think should work but it doesnt.
=IF(COUNTIF($A$2:$A$150,LEFT(A1,LEN(A1)-8)),"Duplicate","")
I need to be able to find duplicates that match except for the date on the
end.
If I could get it to work on the two below then I should be able to apply it
to any of the multitude of headings in the worksheet.
A B C
1 Existing Home Sales (DEC 28)
94 Existing Home Sales (JAN 4)

These need to show as duplicate and I dont understand why the above formula
doesnt work. Any ideas would be welcome!