You are saying you want S, I and J on a third worksheet?
See Chip Pearson's site for formulas to extract uniques from two lists.
Could be something there that will suit your needs.
http://www.cpearson.com/excel/ListFunctions.aspx
Gord
On Sat, 16 Feb 2008 15:25:00 -0800, PAG wrote:
Hi
Since I am new to excel and macros I think it is hard for me to explain what
I am looking to do. I have data on two different sheets that I want to
combine into a new sheet but also not show the duplicate values.
In an excel workbook
sheet1 sheet2
A C
B A
C B
D S
E B
F G
G J
H I
"Gord Dibben" wrote:
David
but you can combine the values in two worksheets with a
simple formula
Not with the formula you posted.
Try =Sheet2!A1 & Sheet1!A1 to combine
Unless you mean to sum the two, in which case your original is OK.
The "+" in "=+" is not necessary.
Gord Dibben MS Excel MVP
On Fri, 15 Feb 2008 15:05:00 -0800, David
wrote:
Sort of lost me here, but you can combine the values in two worksheets with a
simple formula. On Sheet 3 in cell A1 "=+Sheet2!A1+Sheet1!A1". If you are
then trying to get unique values, Data/Filter/Advanced Filter/Unique Values
Only.
Hope that helps.
David
"PAG" wrote:
Hi,
Can anyone please help. I am very new to excel macros.
I am looking to use an excel macro to combine data in a workbook from one
column(A) on a worksheet and one column(A) from a second woksheet into a new
worksheet. The data in the columns in the worksheets could contain the same
data so I would also like to do the folllowing. I would want to sort and
compare the data and have the newly created worksheet show only one set of
data with no duplicates.
Thank You
Peter