Forum Discussion
Problem with Countif function to remove duplicates
Dear all, I am trying to identify duplicates based on a unique string composed from multiple cells using the countif function. Now I encounter an issue where the incorrect value is returned for v...
Use this formula in E2, and copy down rows:
=SUMPRODUCT(--(D$2:D2=D2))
By the way, your original formula works if you concatenate CHAR(173) before the criteria argument like this:
=COUNTIF(D$2:D2,
CHAR(173)&D2)
The origin of the foregoing idea is from Lori Miller in this link:
http://dailydoseofexcel.com/archives/2006/10/10/countif-bug/
See both formulas in the attached file.
Twifoo
Thanks for the help. This precisely was what I was looking for.
Thanks for the help. This precisely was what I was looking for.
- You’re very much welcome!