Duplicates but still not?!?

Hi. I have a table that contains duplicates. If you look at the big picture, and look at the red marking, it should be the one called MH-054 and not the one called 99. If you then look at the small p...