Ive been trying different things but I dont understand why this formula
doesnt work.
=IF(COUNTIF($A$2:$A$150,LEFT(A1,LEN(A1)-10)),"Duplicate","")


"Dave F" wrote:

Assuming something like [ICSC-UBS always precedes the (Feb 3)] create a
helper column that extracts that left portion of the text string and dedupe
based on that. =LEFT(A1,10) should do it.

Post back if you have questions.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"mmcap" wrote:

I have to copy data from an excel sheet on a website to my excel sheet. The
company that I get the data from doesnt separate the DATE from the name of
the data e.g. [ICSC-UBS (FEB 3)] is in one cell. When I paste the data from
the website my sheet still has info that I pasted from the previous month. I
need to be able to identify any duplicate entries but the date at the end
keeps it from being an exact duplicate because the date has changed. The
formula that Im using right now is
=IF(COUNTIF($A$2:$A$150,A115)1,"Duplicate","") this will give me the word
Duplicate in the rows where there is an exact match but I still need to watch
carefully to be able to keep the old data weeded out. Ive tried variations
with RIGHT, LEFT , and , LEN but havent had any success. I need to be
able to ignore the last 6 char €œ(FEB 3)€� in the cell that contains the
[ICSC-UBS (FEB 3)] in order for there to be an exact match. Does anybody
have any ideas?