Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: How to compare entire columns of data?

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have about 200 columns of data.
    Is there a way to check if each column is unique?

    EG1
    A B C D E
    X C D U P
    Y Q R I L
    Z R Y O R
    S Z
    U

    in this example, columns A through E all contain unique data sets.

    EG2
    A B C
    1 O 1
    Y G Y
    T 4 T

    In this case, columns A and C are identical so I want to flag this.

    Any help appreciated!

    regards

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    BTW I would like to do this via a Macro

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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