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...
Hey Ronald_Roos
Try This:
1) Insert a new column and enter this formula to extract the last digit of the number in column D as that is the number that changes:
=RIGHT(D2,1)
2) Then add the CountIF function to the column F. Hide column D if you want to