Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts

    comparing two text (excell)

    I used to compare two column contain numbers easily, but how to to compare if data were text?

    regards
    -Indra-

    I am person with no effort except posting my problem.....

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: comparing two text (excell)

    Can you explain in more detail what you want to accomplish? Do you want to know if items in one column are the same as the corresponding items in the other column, or which items in one column have a match in the other column, or which items in one column don't have a match in the other column, or ...?

  3. #3
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: comparing two text (excell)

    I want to know if items in one column are the same as the corresponding items in the other column,

    Actually I deal with uploading data process which was not work well, and lines data is differ from original data. I want to repair incorrect lines only

    thank for reply

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: comparing two text (excell)

    Say that your data are in columns A and B, starting in row 1.
    Put the following formula in C1:
    <code>
    =IF(A1=B1,"","ERROR")
    </code>
    This will show ERROR in the rows where column A and B are different.

    But if you already know that the original data are correct, can't you simply paste the original data over the uploaded data?

  5. #5
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: comparing two text (excell)

    it works!
    I should have known from beginning.
    I think I become addicted with your help..

    thanks
    -indra-

  6. #6
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: comparing two text (excell)

    .. for some silly reason I'm not authorized to re upload all data. : )

Posting Permissions

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