-1

I would like to know how to compare two columns in two different sheets, and only show the unique values.

I have two lists of email addresses, yet there are some duplicates in them. Would like to know how to get only the unique values of these sheets.

I have already tried the count() function/formula, yet it only counts and displays a number.

Example:

List 1:

- [email protected]
- [email protected]
- [email protected]

List 2:

- [email protected]
- [email protected]
- [email protected]

In this example [email protected] and [email protected] would be the unique values. I would like these to be displayed after the function being executed.

pnuts
  • 58,317
  • 11
  • 87
  • 139
Jeroen ven
  • 3
  • 1
  • Have a look at this http://stackoverflow.com/questions/1429899/getting-unique-values-in-excel-by-using-formulas-only – Kannan Suresh Oct 15 '15 at 10:24
  • Thansk Ian, but it seems it still only removes duplicates and doesnt show only the unique values. Or i am doing something wrong.. – Jeroen ven Oct 15 '15 at 10:56

2 Answers2

0

You can stack the lists by copying and pasting them into one column, then insert a pivot table with the stacked list as the data source. Pull in email address and it will have 1 row per email.

Or, one you have a stacked list, on the data tab, you can use the remove duplicate function to return a distinct list of values.

Wyatt Shipman
  • 1,669
  • 1
  • 10
  • 22
-1

Vlookup is the function you are looking for.

L. Klotz
  • 164
  • 1
  • 15
  • Could be yes, but how? :P – Jeroen ven Oct 15 '15 at 10:56
  • You insert a Vlookup function.. By clicking Formulas - insert function - Vlookup. You can find a full explanation of using the Vlookup function here: [link](http://www.howtogeek.com/howto/13780/using-vlookup-in-excel/) – L. Klotz Oct 15 '15 at 11:07