How to remove duplicates from a column

Hello,

how can i remove duplictes from a colum. For example:

Column C:

A;B;C;A;D;E;A;G;B *(A is three times here and B two times!)
F;G;H;I;F*(F is here two times)

I would like to have the duplicates removed from each cell in column C so that each member is unique in the cell. The example would then look like:

Column C: (after removing the dupplicates A and B in first cell and F in second cell)

A;B;C;D;E;G
F;G;H;I

Thanks for every assistance.

Hi

Have a look at the advanced filter. There is an option to extract out the unique values and put them into another column.


rylo

Hi,
thanks for your answer. I tried it but unfortunately it doesn function. It still gives me duplicates in the new row.

Is it possible to have a small macro for that?

See atttached file. I hope it's what you need.

Regards,
Antonio

Hi,

thank you very much for your help buddy. But unfortunately this doesnt solve me problem. My problem is that i have many columns. And each cell of column C contains of many members. It means that the duplicates inside each cell of C must be removed but not dupplicate cells!

Duplicates inside one cell should be removed in column C.

I will be very grateful if some one could post a code for my problem. Thanks

I apologize for my misunderstand.

See attached file. I hope it's now what you need.

Regards,
Antonio

Hi Antonio,
thank you very much. Thats really very nice of you.

If you could do me one more favour. The problem is that i have a real wordlist and that the example was there just to demonstrate my problem. Now when i run the macro it gives wrong result cus i was not precise enough in my thread. I am sorry. As far i have no idea of programming i cant sometimes explain my problem as precisely as a programmer would do. Sorry!

Well as i said i have a real wordlist which contain for example many words as member of one cell which are sperated with ";":

Column C

love;fondness;love;like;make love


Now in this example not the charactors are supposed to be removed but those members which are there as duplicates. For example "love" is two times there and one of it should be deleted. The result should then look like

Column C

love;fondness;like;make love


Now "make love" shall not be deleted because "love" is not equal " make love".

thanks buddy

See attached file.
I modified my code to do what you need.

Regards,
Antonio

Hi Antonio,

it works perfectly!!!

you saved me at least two months of boring work! Thank you veeeeery much.
You are great!!

thanks thanks thanks thanks...

Glad to know it helped you.

Have a nice time.

Regards,
Antonio