Excel Tips - Remove Duplicates from a sorted list

I am attempting to merge and remove vertical duplicates in an excel list. The attached picture explains what I want to do more fully than any explination I can give. Please post questions if you have them so I can clarify. Thanks!

Does anyone know how to ask Excel to make a fuzzy match? I'm looking for it to see 123 E. Pikes Peak Ave. and recognize that might be 123 East Pikes Peak Ave. or 123 E. Pikes Peak Avenue. I'd settle for figuring out how to ask excel to simply check based on only the first 3 caraters in the cell (which in most cases would be street number). I'm trying to remove duplicates from a list. So I'd like for Excel to alert me to these fuzzy matches by changing colors with conditional formatting, or someting along those lines. (I'm using Excel 2003) I do not want it to delete the duplicate. THANKS!!

If you use excel Data/ Remove duplicates, after operation it will open a window notifying you how many duplicates and how many deleted.
In vba although I have Application.DisplayAlerts = TRUE, the

ActiveSheet.Range("A1:C100").RemoveDuplicates Columns:=Array(1,2), Header:=xlYes
doesn't return anything, although is doing something.
How can I make the vba method to open notify window or fill a string with the notify message.

Thank you.

merge column.xls


Please see attachment is it possible to do that with VBA Macro

below table explain my problem well:

My report result

Oid Eq-Name Contract
123 EQ-001 Ex
124 EQ-002 Ex
125 EQ-003 Ex
126 EQ-004 Existing
126 EQ-004 12345
127 EQ-005 Ex
128 EQ-007 Ex

Output Should Come Like This

Oid Eq-Name Contract
123 EQ-001 Ex
124 EQ-002 Ex
125 EQ-003 Ex
126 EQ-004 Existing,12345
127 EQ-006 Ex
128 EQ-007 Ex


Any solution

Thanks in advanced
Chintan

I am looking for help with a simple way to go through a list and copy unique values onto a different worksheet. I have a long list of phone numbers I need to go through and basically count how many times each one occurs. Counting each occurence isn't the problem, it is just getting a single list of unique numbers. As always all help is welcomed and appreciated.

Hello

I wonder if someone would be able to assist me. ive tried googling it but as yet havent found anything that works and my brain is literally starting to melt

please be aware my excel knowledge is very basic ive literally just started using it so could do with step by step assistance if possible! Heres what im trying to do:

I have two lists obtained from different sources. the master list contains rows of people (sheet 1) that i have already contacted. On a weekly basis i have another list of rows in a 2nd list (sheet 2) that i want to compare against the 1st list and remove any duplicates from the 2nd list so they are not contacted again.

Any idea of how i can easily do this?

Thanks in advance!!!

Me again.

Looking at Sheet1, J3 is a drop down list that contains customer ID on Sheet2.

Everything works as it should. Only thing is that there can be several rows of data pertinent to one Customer ID. So how would you have the drop down list show only one Customer ID, but retrieve all the rows of data.

Did that make sense?

Thanks in advance,

George

HI All

I have two columns of hexadecimal four figure numbers, in column A I have all possible numbers from E000 to EEEE. In Column B I have a list of hexadecimal numbers which lie in the range of Column A.

What I want to do is create another column which contains only the 'unused' numbers that don't appear in column B at all.

I have Excel 2003, and tried the 'advanced filter' but this only deleted all duplicates, leaving me with my list as in col A

Help would be appreciated

(If you are curious, the codes are called PI codes, used to implement the RDS automatic tuning function on car radios. Each radio station in a country is supposed to have a unique one. The list is from Spain, where they all [should] start with E)
Thanks, Andy

I'm looking for help with an array formula that will condense a long list like this:

a
a
a
b
c
b
d

To this

a
b
c
d

thanks!