Address Lists

The UK's most regular instructor-led training courses.
Training information: excel course · Excel training courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Address Lists

Robert has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course

by - delegate Robert [4 posts] (2008 Mar 25 Tue, 09:47) Reply

Given two address lists that include many exact duplicates, can I get Excel to hightlight those that are NOT duplicated between the two lists? Can this be done without sorting the lists? Thanks RH

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Address Lists

by - trainer Rich platinum contributer [744 posts] (2008 Apr 25 Fri, 22:51) Reply

you could try adding a pivot table based on address line one for example. For each address line it will sum up how many rows have the same one. If there is a value of 1 in the table then there are no exact matches.

· Excel and Inventory Management
· Benefits of learning about Excel charts
· How to Create Better Excel Spreadsheets: Part Two
· Why Should I Learn Visual Basic in Excel?
· Interesting Lifestyle Applications for Microsoft Excel

Please browse our web site to find out more about
excel course and other Microsoft training courses.