Combine two lists

[Charity]

okay so I tried to make a custom function but failed.  I have two lists and I want to make a single list but remove any duplicates.  Ideas?  If I can just get started, I would like to make this cf by myself but I do not know how to start.  I need recursive, right?  Take one list and loop it and compare to second list and then what?  And happy early new year!

[Ocean West]

My favorite to solve this..

CustomList ( Start ; End ; Function ) http://www.briandunning.com/cf/868 

UniqueList ( ListA ; CaseSensitive )  http://www.briandunning.com/cf/789

The first function is used by the second one. You would just call the CF as UniqueList ( List ( table::listA  ; table::ListB ) ; 0 )  the last flag is if you wish to consider case sensitivity for uniqueness.

These are very powerful functions that do much more the first one can return some very useful results, read the samples embedded in the code.