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 <(E-Mail Removed)> 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 <(E-Mail Removed)>
>> 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
>>
>>
Similar Threads
