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!