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?