Seems to me that an IF (logic) function is one way forward. Msfab's is a good example (my own personal preference would be to configure a logic function of this kind, but you do need to have some idea of what you are doing to write the function in the first place.). You can use these formulae for large spreadsheets (back in the 1990s - 1994 to be precise - I was using logic functions on 10,000 row spreadsheets in whatever the then-current version of excel was).
If you are prepared to do things manually, you can use the datafilter tool (basically, select your "names" column, click on "Data" then "autofilter". You will then see a "down button" appear on the column you selected . Click on that down button and you should have a list containing each different entry displayed once. If you click on e.g. a name on that list, it will bring you up all the rows where that particular name appears on the column you selected. You can then leave/delete the data in that row as you wish.
Bookmarks