Jump to content

Combine two lists


Charity
 Share

This topic is 2375 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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!

Link to comment
Share on other sites

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. 

Link to comment
Share on other sites

This topic is 2375 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.