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 picture, there are lines that should contain 99, like the green one the selection. There are also 99 in the red marking, but these have different data in the column that the arrow shows. But the green makings in the big picture, I do not understand how to get rid of.