+ Reply to Thread
Results 1 to 3 of 3

Finding Unique Values across four columns.

  1. #1
    Registered User
    Join Date
    07-09-2008
    Location
    Brighton, UK
    Posts
    79

    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!

  2. #2
    Registered User
    Join Date
    07-09-2008
    Location
    Brighton, UK
    Posts
    79

    Re: Finding Unique Values across four columns.

    Can anyone help with this?

    Thanks,

    Matt

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Finding Unique Values across four columns.

    Hello barksmith,

    It would be both easier and faster to code a solution if you post a sample workbook. It also helps to know which version of Excel you are using.

    Also, also...How easy is it to make my own tab in the ribbon with all my own macros on it?
    Form this quote, I gather you are using Excel 2007.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1