Hi,

I recieve a spreadsheet every month containing names as well as numerous other cells of information. Each month, new details are added to the bottom of this spreadsheet. What I want to do is find a way that the newer data can be compared with the older data to see if there are any repetitions (which is expected). eg I would like to be able to see how many times Smith, J has been entered. One other issue is that sometimes the names are entered as Smith, J or sometimes Smith, J - is there anyway just to search the initial part of the name?

Thanks in advance - as there are over 400 entries on this spreadsheet, any help to avoid the process being manual would help!

Alex