G Guest Jan 21, 2004 #1 I have 2 different sheets and I am trying to make 1 list by merging. Do I need to merge by column or can I somehow do it by the whole sheet thanks
I have 2 different sheets and I am trying to make 1 list by merging. Do I need to merge by column or can I somehow do it by the whole sheet thanks
D Dave Peterson Jan 22, 2004 #2 Depends on what you mean. If you have two lists (each one column), then you could create a new worksheet copy the first list in A1 copy the second list at the bottom of the first list Data|Filter|Advanced Filter and click "unique records only" and plop them into B1. then delete column A. Debra Dalgleish has some notes with pictures at: http://www.contextures.com/xladvfilter01.html#FilterUR ==== if you have multiple columns of other data, you could do the same thing, then use a bunch of =vlookup()'s to retrieve the columns from each sheet that you wanted to keep.
Depends on what you mean. If you have two lists (each one column), then you could create a new worksheet copy the first list in A1 copy the second list at the bottom of the first list Data|Filter|Advanced Filter and click "unique records only" and plop them into B1. then delete column A. Debra Dalgleish has some notes with pictures at: http://www.contextures.com/xladvfilter01.html#FilterUR ==== if you have multiple columns of other data, you could do the same thing, then use a bunch of =vlookup()'s to retrieve the columns from each sheet that you wanted to keep.
