delete duplicate rows..

so i now have the macro for the helper column and for the delete duplicate entries but i cant get the two to combine into one macro.. if i run them separately, they work fine. But I can't get the helper to work with the combined one.

So if you run helper first, then deleteduplicaterows, it works fine. but then if you paste the orginal data back and run combined it deletes all the rows but one and the formula nor the value of the cell is the same. i know i have something in there wrong. But I don't see it right now.