Getting a list from raw data without repetitions

[VanniFucci]

Dear all

I'm trying to figure out how to achieve this and I believe a Macro is the way to go but I do not know how to write it.

Say you have a column with a list of items, some of which repeat themselves:

ITEM A
ITEM B
ITEM C
ITEM A
ITEM D
ITEM D
ITEM B


I would like to find a way to have (from that row data) a column which shows the name of those items without repetitions:

ITEM A
ITEM B
ITEM C
ITEM D


I'm not looking for sums or similar (I will deal with that myself), just a way to have a neat column without the repetitions.

Thanks a lot in advance!

Vanni

[kasan]

You could use excel build-in solution. Select your data, then select Data ribbon and choose "Remove Duolicates".

[bradl822]

Agree with Kasan, however VBA solution:

Please Login or Register  to view this content.

[VanniFucci]

Thanks guys. The solution you suggest removes the duplicates from the original column. What I need is to have the list without duplicates in another column, better if on another sheet, without altering the original list.

Apologies if I was not too clear in my original post.

[kasan]

Try this one:

Please Login or Register  to view this content.

[VanniFucci]

Thanks a lot Kasan

I actually found a pretty easy way round it using just a formula

=IFERROR(INDEX(List,MATCH(0,COUNTIF($B$1:B1,List),0)),"") + CTRL + SHIFT + ENTER

And drag down

Thanks anyway!