IF statement question

  • Thread starter Thread starter trevorbragdon
  • Start date Start date
T

trevorbragdon

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Baffeling IF statement 7
Compare identifier columns from 2 sheets - remove rows that are dups 2
Multiple arguments 1
Find Duplicates in a Schedule (Two fields: Time and ApplicantID) 1
IF statement to check for numerical value 3
If Statement Question 4
Nested If Statements 7
Scrabble Value calculation for Welsh words 0

Back
Top