Delete duplicates in row leaving value on right hand side

Hi all,
I've got a data set where i need to remove duplicates from each row. I cannot use the remove duplicates feature as the data has an outline so I was hoping to be able to use VBA... The range will always be P(row number):AW(row number) and I always want to leave the 'latest' number - i.e, in the attached screenshot, i'd want to leave the values in columns R and T - ergo, the values in columns Q and S should be removed.

First question, I guess, is "can this be done in VBA" and then "how do I go about it"?

Capture.PNG

Thanks as always!
Jon

My apologies, team - attachment now uploaded.

Yep - there are likely to be a number of duplicates (currently no more than 15) all adjacent to eachother.

Hi !

Amounts belong only by pair or it can have more than 2 values within a row ?

Thanks everyone - all responses have helped me greatly!

Cheers,
Jon