Re: Stuck for a Solution

Tech-Archive recommends: Fix windows errors by optimizing your registry

First of all you need to obtain a unique list of names from both sets,
so insert a new work*** and copy columns A and B from the existing
*** into the new ***, including the headings. Then copy the names
from D2:E2 and below, and paste them immediately below the names you
already have in A and B of the new ***. Highlight the combined list
of names in the new *** (including the header row), and then click
on Data | Filter | Advanced Filter. In the pop-up you should choose
Unique Records only, and also Copy to another location, and specify D1
as the destination, and then click OK.

This will give you your unique list in columns D and E, and you may
wish to delete columns A to C as well as sort the names, because the
ones that are unique to the second list will appear near the bottom.

You can then use a VLOOKUP formula to bring the data across to this
new ***.

Hope this helps.

Pete

On Apr 5, 7:22 pm, debra <de...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I have two sets of data that I am struggling to combine withiout having to do
so manually.   The data is from two different years, some names appear in
both lists, some only in one list and not the other (sample below).  I need
to combine the two sections of data into one list, eliminate the duplicate
names and combine the data for the duplicated names in to one entry.

first          last           07-08        first          last           06-07
Connie  Aalderink       16      Connie  Aalderink       24
Ryan    Aalderink       8       Jerry   Aardema 27.75
Jerry   Aardema 51.5    Mary    Abbring 41.5
Reta    Ademe   30.75   Reta    Ademe   11.5
Adan    Aguilar 32      Nikki   Afendulis       16
Anthony Aiuppy  24      Adan    Aguilar 37.5
Khamtanh        Akhavong        31.25   Patricia        Aittama 28

What I need to do is if the name appeats in the 06-07 AND 07-08 columns.  I
need move it to a new report that combines the data with first name, last
name, 06-07 and 07-08 data so it looks something like the sample below.  

I also need to move the data that is unique to one list and not the other
list,

first   last    07_08   06_07
Connie  Aalderink       16      24
Ryan    Aalderink       8      
Jerry   Aardema 51.5    27.75
Mary    Abbring         41.5
Reta    Ademe   30.75   11.5
Nikki   Afendulis               16
Adan    Aguilar 32      37.5
Patricia        Aittama         28
Anthony Aiuppy  24      
Khamtanh        Akhavong        31.25  

Have tired several ways around this and not finding a solution that works.

Appreciate any assisstance
--
debra

.

Quantcast