Remove Duplicates In All Rows Based On Column A Only

[BriUni]

I'm looking for help removing duplicates in all rows based on Column A only.  Please see attached video for explanation.

[#2]

Simply uncheck the appropriate boxes in the remove duplicates dialog!

[#3]

Oh wow...I feel pretty dumb now! I thought for sure I had tried that. Thanks for your help!