You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Merge two columns/lists into new single column/list removing duplicates (formula)

Merge two columns/lists into new single column/list removing duplicates (formula)

Price: FREE

I have two columns of data. I'd like to merge the two columns into a new single column which would contain only unique values. I need a non-array formula that will do the work (e.g. I cannot use advanced filtering). Here are some conditions that may also be useful to know:
1) Within the two data columns, all entries are unique. The duplicates exist across the two data columns.
2) The data columns are created programmatically. The number of rows of data in each column can therefore change. I have created dynamic named ranges that adjust to the length of each data range called List1 and List2.
3) If it helps, I can add helper columns to either data column, although my preference would be to avoid this.

Visit publisher's web-site: Merge two columns/lists into new single column/list removing duplicates (formula)

Category and Tags: ExcelTutorials :

Related Tutorials

Removing duplicates from two different lists

Free: Yes
Tags: Excel ›

I have two databases of clients first and last names, List 1 are the clients I want to send emails to and List 2 are the clients I have sent emails to. However, List 1 still contains some clients that have already received emails. I don't know any method of cross referencing list 1 and list 2 to exclude any clients that have already received emails from list 1.

Excel merge columns

Free: Yes
Tags: Excel ›

I have two different lists. List A with three columns: name, first name, email address and list B with 7 columns: name, first name, Street, City, Post Code, Country.
The list B contains the names of list A. How do I merge these two different lists, so that the e-mail address appears as separate column of List B?

Need a Single list of names from 4 columns, no duplicates

Free: Yes
Tags: Excel ›

I have a range of names "AQ3:AT37". Their are duplicate names in the range and while their are no gaps in each column list, each column is not a full 35 names long, they all vary around 20 some names each. Starting at "AU3" I want to produce a single column list with no duplicates.

Removing duplicates based on three columns

Free: Yes
Tags: Excel ›

Not fantastic at Excel and have seen the FAQ in removing duplicates but I need identify the duplicates based on column A,B and C and have no idea how to do it.

Merge two e-mail lists

Free: Yes
Tags: Excel ›

I have two e-mail lists one with e-mail column A and name in column B. The other lists E-mail column A and Country column B. All the e-mails in list one are in list two, but not all e-mails in list two are in list one.
I would like to merge these two lists so I get e-mail, name, country and the ones that are not in list one just without country.
I was told to try with a pivot table, but cannot seem to get that to work as I don't know how to get two lists into this.

Related Applications & Scripts

Split Merge PDF

Free: No
Tags: Software › Excel PDF Generation

Split Merge PDF files with PDF splitter & Merger Software phenomenally combine pages from the input PDFs to create a new PDF and split a file in to single pages as well as multiple pages, small in size pdf files based upon the page ranges & page numbers. It is easier, simplest and light weight software that combines two or more Acrobat PDF files into a single PDF document. PDF Splitter and merger is software to split multi-page PDF document into single page PDF document.
Split Merge PDF is stand alone software which provides both facility splitting and merging. Merger function has capability to merge more than one file in to one PDF file and save it to user defined location. Splitter Function has ability to split one PDF file in to single page as well as multiple pages PDF document according to user requirement. Both functions have page range option which is used to merge or split page number. PDF splitter and merger don't need any software such as adobe acrobat. Software comes with graphical user interface so that any one uses this application with any help or any technical knowledge.

Auto FollowUp Plugins

Free: No
Tags: CGI and Perl › Excel Mailing Lists

Auto FollowUp has been made to work with additional plugins. Some of the added features included in this are:
1. A 'subscribe by email' script so users can add or remove themselves automatically from your lists by sending an email.
2. A merge script which allows you to upload comma and pipe delimited text files and merge their fields with your AutoFollowUp databases.
3. A mailing list script which allows you to send to all users who check the 'add to mailing list' check box in your AutoFollowUp Forms.
These additional scripts help make AFU one of the best selling scripts on our site! Buy it today.

Mega List Cleaner : Mailing Lists Cleaner

Free: No
Tags: PHP › Excel Mailing Lists

You might be wasting your time and resouces working with a mailing list that is is not clean!
Incorrect or duplicate data could be costing you money and time. You might even get a legal notice for spam etc.
Mega List Cleaner is the ultimate list cleaner, duplicate remover, list sorter, unsubscription cleaner, email validator, name capitalizer etc for your mailing list.

Filter Large Select Lists

Free: Yes
Tags: JavaScript › Excel Forms

If you have a very large HTML SELECT list, finding the correct item can be like looking for a needle in a haystack. For example, if you have a list of a couple hundred names, finding a single one can be difficult. This article provides a JavaScript technique for filtering the items in a select list so that only the matching items are shown, making it much easier to locate the desired item.

Mailman Mailing List Manager

Free: Yes
Tags: Python › Excel Mailing Lists

Mailman is Python-based software to help manage email discussion lists, much like Majordomo and Smartmail. Unlike most similar products, Mailman gives each mailing list a web page, and allows users to subscribe, unsubscribe, etc. over the web. Even the list manager can administer his or her list entirely from the web. Mailman also integrates most things people want to do with mailing lists, including archiving, mail-to-news gateways, multiple list owners and moderators, and so on.

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing