+ Reply to Thread
Results 1 to 3 of 3

IF statement question

  1. #1

    IF statement question

    I have a data set that has several thousand names and I am trying to
    remove any duplicates. I used the formula IF(A1=A2,0,1) but the fields
    I know are identical are returning "1". I think it might be a format
    problem, but it has me stumped. Thanks


  2. #2
    Marcelo
    Guest

    RE: IF statement question

    try it:

    http://www.j-walk.com/ss/excel/usertips/tip027.htm

    hth
    regards from Brazil
    Marcelo

    "[email protected]" escreveu:

    > I have a data set that has several thousand names and I am trying to
    > remove any duplicates. I used the formula IF(A1=A2,0,1) but the fields
    > I know are identical are returning "1". I think it might be a format
    > problem, but it has me stumped. Thanks
    >
    >


  3. #3
    Fast Learner
    Guest

    RE: IF statement question

    You can also try this site:
    http://www.cpearson.com/excel/duplicat.htm
    I found this site very useful.
    "Marcelo" wrote:

    > try it:
    >
    > http://www.j-walk.com/ss/excel/usertips/tip027.htm
    >
    > hth
    > regards from Brazil
    > Marcelo
    >
    > "[email protected]" escreveu:
    >
    > > I have a data set that has several thousand names and I am trying to
    > > remove any duplicates. I used the formula IF(A1=A2,0,1) but the fields
    > > I know are identical are returning "1". I think it might be a format
    > > problem, but it has me stumped. Thanks
    > >
    > >


+ 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