Hi there,
I tried Googling this (for hours) to find a pre-existing answer - however I'm afraid I still can't work this out by myself (I'm a bit of newbie to OpenOffice Calc).
I have a sheet of product data where all product attributes are stored in a single column.
I tried to detect if the row exist some duplicate text ot name. My idea is to copy some text from the website and to check it for dups.
the text is copied with the time front, which prevents correct reporting for the duplicate. it would also be able to read the names before and after the dash mark.
The column data looks like the list below:
03:21Oliveira, Charles - Lentz, Nik
03:20Oliveira, Charles - Lentz, Nik
03:10Oliveira, Charles - Lentz, Nik
the formula that I use is: =IF(COUNTIF($A$1:$A$9999;A17)>1;"Duplicate";"")
I believe it should include some exceptions witch I can't find and add to this formula.
Any tips on how to do this would be greatly appreciated!!
Thank you in advance.