Finding Unique Values across four columns.

Hi all,

We recieve alot of data here, and when we recieve data, the phone numbers are in 4 columns. The first column will be completely full, then the second, third and fourth column will have different numbers in each field and may not be full.

The probem is, these four columns cannot contain the same numbers, so essentially I need to de-dupe all the numbers. The primary column will be column A which is completely occupied with numbers, so no number should ever be deleted out of this one. But the numbers in columns B,C and D will need to be deleted if they match column A.

It also needs to check that if it doesn't match column A, check B against C, C against D etc until each row contains entirely different numbers. All four cells in a row can be occupied but that must be with different numbers.

Also, can i link this to a range? so, if I always named these four columns to say 'Number Sort' all I'd have to do is click to run this macro and it runs?

Thanks in advance.

Matt

Also, also...How easy is it to make my own tab in the ribbon with all my own macros on it?


Thanks again!

Can anyone help with this?

Thanks,

Matt