I have a list of MAC address formated like: xx:xx:xx:xx:xx:xx. This list
also contains the customers address. The MAC address is in column A and
address in column B.

I need a formula or a macro that will sort the MAC address along with
the respective address, then show me the ones that have been entered
wrong (to few or to many numbers), and are doubled (MAC addresses that
have been entered twice.
I can upload a sample (with no real numbers) if need be.

Thanks in advanced for your help!:)


--
TnMike
------------------------------------------------------------------------
TnMike's Profile: http://www.excelforum.com/member.php...o&userid=33916
View this thread: http://www.excelforum.com/showthread...hreadid=536947