Take out unique values from each lists and put them together

[Petijandro]

There are 3 lists (CC, PC, NB), these lists are always updated from an outer source (so the column's length usually changes)
How is it possible to take out all the unique values from the PC and NB lists (which can't be found in the CC list) and put them to the end of the CC list

I attached the xlsx.

sample.xlsx

[Fotis1991]

So in your example only last row of both PC & NB lists, IS UNIQUE. Correct?

If yes, maybe we can create a new list with ALL uniques values from all three lists.

[Petijandro]

There are no unique values in those 2 lists in the example sheet (i uploaded the wrong one but you can add unique data manually).
Yes, the point is to create a list from all unique values from the 3 lists.

[Fotis1991]

=COUNTIF($A$2:$A$6000,C147)

Result in this is 0. For all the others numbers in column C, the result is 1. So this looks to be the only unique number...

[Petijandro]

I used conditional formatting for unique values and it didn't highlight any values but it seems like it doesn't work that way.

[Fotis1991]

One more question. Are your real data like your example? What i mean is if the columns with your data could be continious(like for example column A B C) or these are like your example A E G)?

[Petijandro]

The example sheet is basically my real data. When it is updated from an outer source the format stays the same. (A, C, E, columns for CC PC and NB respectively)
The "unique" list can be anywhere, it will be extracted to an other sheet

[Fotis1991]

As i have a meeting in 10 minutes and also i have some phone calls to do, i don't have time to create this now.

But see this excellent site about uniques list and i believe you'll do it alone. If No, let me know and i'll see it later.

http://www.get-digital-help.com/2009...umns-in-excel/

[Petijandro]

Thank you! I'll rep you as soon as the system lets me

[Petijandro]

I just figured out that I was talking about something else the whole time, no wonder we didnt understand each other.
So..
All I want to do is put the 3 lists together and remove the duplicate entries so there will only be unique values in the combined list.
Manually I would copy the List2 and List3 under list1 and do a "remove duplicate entries" but it has do it automatically

[Fotis1991]

...I just figured out that I was talking about something else the whole time, no wonder we didnt understand each other.

Mi más nyelvet beszélnek, és próbál kommunikálni angolul.

Does the translate is correct?What i mean is this.

We speak a different language and trying to communicate in English.

So it's logical to don't understand it's other..

Thanks for the feedback.

[Petijandro]

Haha, almost correct
Yeah sadly it happens sometimes.