98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Address Lists
Address Lists
Resolved · Low Priority · Version Standard
Tue 25 Mar 2008, 09:47Delegate Robert said...
Robert has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Address Lists
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
Fri 25 Apr 2008, 22:51Trainer Cress said...
RE: Address Lists
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:DATEDIF functionThe DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002. |
