Help with Summing Duplicates, deleting rows after summing and filling col. for unsummed

Hello;

I am beginning to work independently but this request has given me fits. I am attaching an example of my spreadsheet, although the real data is over 50,000 lines.

What I need to do is find duplicates in Column C.
Sum column R for those duplicate values into an inserted Column S, then delete the duplicates that don't have the sum in S.
Once that is done I need to take all the values in R for the non duplicates and copy them into S.

I figured out how to get the Summing done but everything I tried to delete the duplicates and them fill the non duplicates into S has failed. Any Ideas would be great.

The code I used to do the summing was

Please Login or Register  to view this content.

Thanks for any assistance you can give

Gene

Example.xlsx