Return a combined unique list into one from other two lists.

Put this array formula in G6.

Formula:

Please Login or Register  to view this content.

Important: this is an array formula so needs to be entered using Ctrl-Shift-Enter not just Enter. You will know the array is active when you see curly brackets { } appear around your formula - don't try to enter them yourself. If you do not Ctrl-Shift-Enter an array formula you will get an error or a clearly incorrect result (in this case, you'll get '^^end of list^^'). If that happens, just click into the formula bar and try again.

Then drag down until you get '^^end of list^^'.

To get the new serial numbers, enter this in F5 and drag down:

Formula:

Please Login or Register  to view this content.

You can replace "^^end of list^^" with just "" if you'd prefer blanks. I only use this so that you can see easily where the list stops.

I hope that does what you need.


By the way, for future reference, please note that what you have asked for is a combined distinct list not unique list.

Unique values are the items that appear in a dataset only one time.
Distinct values are all the items in a list ignoring repeated values.
For example, in this list:

A B C A B A D

the unique values are C and D (they only appear once)
the distinct values are A B C and D.

You're welcome, glad I could help and thanks for the rep.

If you're satisfied that your question has been answered, then please take a moment to mark the thread as Solved so others know there's an answer here (instructions are in my sig). Thanks.