Deleting duplicate records

[trinden]

I cannot get this formula to work.What am i doing wrong?Could someone help me please?
=IF(J2=J3;"xxxx";" ")

Chris

Edit: Hagar: changed the title (was just 'help' )

[squenson]

It works as expected on my PC. Could you be more precise:
- What result do you get (or error message)
- Which version of OOo, OS and language settings (both for OS and OOo)
- You could also attach a sample file (click on "upload attachment" below the submit button when you prepare your answer)

[Hagar Delest]

Please read the Survival Guide for the forum. Change your title.

And we need more details of course as said by squenson.

[trinden]

I 'm getting xxxx when i enter the code.I'm not sure which version i have.What's the latest version and could you send me a link?The language setting i have is"Western Europe(windows-1252'winlatin1)I tried to upload the file but it said cvs extention is not allowed.
Thanks for all your help
Chris

[kingfisher]

If you get that result, J2 and J3 are equal. What values do you see on the input line?

[trinden]

Ok,but what i'm trying to do is delete all the duplicate records i have in this particular file,which is very large.It would not let me copy and paste it.What should i do.

Chris

[kingfisher]

Perhaps the COUNTIF function would help; for example: =COUNTIF($A$1:$A$1000;$A1)

The example assumes that your range is A1:A1000. You would insert that formula in, say, B1 and copy it down to B1000. Any result above 1 would indicate a duplicate entry.