formula for adding columns

  • Thread starter Thread starter Daniele M.
  • Start date Start date
D

Daniele M.

Hello,
I am searching for a formula that got two columns (char data) returns as
result a new column with listed all the value between the two colums without
reptitions.
For example suppose we have the following two columns:

column 1
5698dany76
5698gio73
5698raf74
5698enr76
-
column 2
5698fra00
5698dany76
5698enr76
5698dav00

I would like to have as result the column 3:

column 3
5698dany76
5698gio73
5698raf74
5698enr76
5698fra00
5698dav00

pratically a formula that matches the two columns and in the resulting
column reports all the data that are present in two columns without
reppetitions:

Does it possible?

Grazie Daniele M.
 
Hi Daniele,
Take a look at Chip Pearson's functions.

http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique

You can use a combination of "Extracting Values Common To Two Lists" and "Extracting Values On One List And Not Another" to get what you want.

Good Luck,
Mark Graesser
(e-mail address removed)



----- Daniele M. wrote: -----

Hello,
I am searching for a formula that got two columns (char data) returns as
result a new column with listed all the value between the two colums without
reptitions.
For example suppose we have the following two columns:

column 1
5698dany76
5698gio73
5698raf74
5698enr76
-
column 2
5698fra00
5698dany76
5698enr76
5698dav00

I would like to have as result the column 3:

column 3
5698dany76
5698gio73
5698raf74
5698enr76
5698fra00
5698dav00

pratically a formula that matches the two columns and in the resulting
column reports all the data that are present in two columns without
reppetitions:

Does it possible?

Grazie Daniele M.
 
Back
Top