Hi,
I have a range of account code in a column and i would like to find out whether there are duplicate items or not. Which formula function is to use to detect it?
Thanks in advance
Hi,
I have a range of account code in a column and i would like to find out whether there are duplicate items or not. Which formula function is to use to detect it?
Thanks in advance
Last edited by mingali; 06-03-2010 at 08:05 PM.
=COUNTIF(A$1:A1,A1)>1
copied down, will enter TRUE when a duplicate of an already existing name comes up.
Only the Duplicate(s) will have TRUE, not the first occurence.
This way you can then filter for TRUE and delete those if desired.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi NBVC,
Would you please check what has gone wrong with the worksheet? Row 21 is true while there is no duplicate while row 39 is false when there are duplicates.
What cause this issue?
Thanks
It was assumed you were starting at row 1, in your case, enter in C3:
=COUNTIF(A$3:A3,A3)>1
and copy down
Or you can put this in C3 and drag down..
=IF(MAX(COUNTIF(B3:B99,B3:B99))>1,"Duplicates","No Duplicates")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks