merge and de-dup two Lists?

[mscholtz]

Is there a good way to combine two lists (in the sense of the List function, i.e. a CR-delimited list of text values) and also de-dup them? Order doesn't matter.

So if I started with:

blue

red

yellow

and

green

blue

red

I'd want to end up with

blue

red

yellow

green

I can combine the two with the List function, but that doesn't remove the duplicates. And no, it wouldn't be super easy to put these into a ValueList, I know that would de-dup.

I'm guessing the answer is a custom function. Anyone got one like this?

Thanks!

[mr_vodka]

Since you have advanced, maybe this Custom Function can help.

[mscholtz]

Thanks, Vodka! That's basically what I was looking for.

I thought about writing a function myself, but I guessed this was something someone else had already done.

Thanks again!