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...