I need VBA code to select cell in column C, rows 9-76 that are duplicate of all but first occurrences of names in column A, rows 9-76. In those selected cells I need to put the message "Not Eligible" and then lock those same cells. This is a list of lot owners in a HOA that own lots. Some own more than one lot but still only get one vote on issues.

I don't know if it makes a difference but I am using a Mac OS 10.8.1 With Excel for Mac 14.2.3.
Thanks for any help in advance.