|
|
#1
10-29-2012, 01:30 AM
|
|||
|
|||
Excel 2007-How to merge multiple records into one
I needed help with merging multiple records into one.
In the attached spreadsheet I have the same user having access to multiple applications. What I need to do is compare the last, first names and the department and if they all match (b'coz there are some users with the exact last & first names, but in different depts) then merge the records into one and mark "Y" for all the applications the person has access to. Also, in my worksheet I have last names in all caps, or sentence case etc. I tried converting it to proper case (sentence case-e.g.Martin). But I get an Invalid ref. error. Why? I would greatly appreciate a quick response! Many thanks in advance! 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Multiple mail merge records on the same page
|
allenglishboy | Mail Merge | 3 | 07-18-2012 06:22 AM |
|
Access to Word, Creating a list from multiple records
|
daymaker | Mail Merge | 9 | 03-14-2012 06:37 AM |
|
How can I retreive multiple records using a lookup?
|
jrpey | Excel | 3 | 11-14-2011 02:10 PM |
|
Merge Doc skips records
|
eonelson | Excel | 11 | 01-30-2011 03:49 PM |
| Help with consolidating multiple records into one | wbiggs2 | Excel | 0 | 11-30-2006 01:02 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode