Hello,

I've have got two lists of data. The first is a list of addresses with
each address having an address identifing number. The second is a list
of people at those addresses each name having the address indentifing
number to link them to the first list. There is usually more than one
person at each address but I want to limit this to one person at each
address for the purpose of eventually mail merging.

Advance filtering does not work as the name are different and so wil
not filter as unique records. Can anyone suggest how to cut down to one
person at each address?

Thanks in advance

Graham


--
el_grimley
------------------------------------------------------------------------
el_grimley's Profile: http://www.excelforum.com/member.php...o&userid=25924
View this thread: http://www.excelforum.com/showthread...hreadid=394153