G
Guest
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 I’ll just say that I have to use other people’s
data.
Here is the formula that I think should work but it doesn’t.
=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 don’t understand why the above formula
doesn’t work. Any ideas would be welcome!
long and boring explanation as to why the dates are in with the headings and
other odd setup practices I’ll just say that I have to use other people’s
data.
Here is the formula that I think should work but it doesn’t.
=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 don’t understand why the above formula
doesn’t work. Any ideas would be welcome!