#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 137
Default Merge Data

I have to compare student names on spreadsheets to determine if a university
can be paid. I have a master list of all the students that are eligible for
payment and then I receive another list of students from the University and I
have to make sure they are on the Master list prior to paying.

There are about 600 students per list so I would like to be able to add only
the new students that are currently not on the master list so I don't have
duplicates.

Is there a way that I can do this without deleting the duplicates manually?

Thank you
--
Brenda S
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge data in two worksheets based on key data value (like databas bevpike Excel Worksheet Functions 1 September 13th 07 10:56 PM
Can I merge data in 2 sheets matching rows of data by last name? Corb Excel Discussion (Misc queries) 1 March 18th 07 05:32 PM
mail merge excludes my headers and critical data in Word merge Nix Excel Discussion (Misc queries) 0 April 21st 06 08:35 PM
how do i get my mail merge to update the data source at each merge Steel_Monkey Excel Discussion (Misc queries) 0 November 30th 05 08:41 AM
merge data mhei Excel Worksheet Functions 3 April 11th 05 10:45 PM


All times are GMT +1. The time now is 01:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"