Tim Carter

unread,
Sep 6, 2014, 10:03:51 AM9/6/14
to mitappinv...@googlegroups.com
I did a search, not a lot came back, so after figuring it out, thought I would share back these two snippets. No doubt they need improving or it has already been done somewhere else.


Remove duplicates for a single list:

Just to make it clear what is happening I sent the output to another list, as opposed to overwriting the original one.

Using a for each block, 

  • get the list with duplicates
  • check if the item is in the new list
  • if it isn't add it to the list
  • if it is, don't add it to the list
  • tidy up

Compare Two Lists and Remove Duplicates before Combining:


removes duplicates from the second list by checking each item from the first, then combines the two lists to a new list.



Reply all
Reply to author
Forward
0 new messages