Duplicate formula

M

Mark Allen

I am using this formula to de-duplicate a spread sheet

=IF(COUNTIF($A$2:A2,A2)=1,"First Occurrence","Duplicate")

However, if one cell has a "9" in it and another has "99" in it, it thinks
it is a duplicate.

Is there a way to make it check for a complete match ???

Hope some can help !!

Regards

Mark
 
T

TomPl

I have tested your formula and do not get false matches as you have described.

Tom
 

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

Segregating Duplicate Transactions 3
Duplicate data 2
Problem with IF formula 1
Marking duplicate entries based on multiple columns 5
Highlight duplicate cells based on a selected cell 5
Need formula to Check Duplicates 2
Help with a formula 2
locating duplicates 4

Top