Merging 2 sets of data

[Alex]

I am going to be merging 2 sets of data, one of 2006 information and one from
2007. In each year there are different university names, which I have in my
rows, and the amount of students who applied for each year in the columns.
Like the example below

Uni Name 2006 2007
Brighton 23 8

My dilemma is that I am getting each set of data from seperate places, and
some univeristies will be the same while others will be different. I want to
create the spreadsheet so when I copy both sets of data, duplicate entries
are removed and the data for 06 and 07 line up next to the university name.
Is there a way of doing this? I am aware of mail merge but have never really
used it.

Cheers

 

[john the confused]

Try pasting the information in to a spread sheet so the years line up and
then use the Advance Filter function under the Data menu. (I assume the
duplicates have exactly the same infomation). You have the option to filter
the list in place and remove any duplicates by putting a tick in the unique
records only check box.

If you want you can then copy this list to a new sheet.

John