Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merging 2 sets of data
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merging 2 sets of data
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 "Alex" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
help comparing two sets od data to find the odd data | Excel Worksheet Functions | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) |