VBA for Adding Unique Values in Row to Column D

[BraytonM]

Hello all,

I am looking for a VBA to do the following: add the unique values in rows that aren't blank to column D. Column C adds up the unique values per row (range R:AQ) and I have a macro that adds X values above based on that value.

I have attached a before and after of what I would like the macro to do. Hopefully, y'all can help me!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.