The uploader said the xlsx file extension wasn't supported, so I had to upload a zip. Thank you for any help you can offer!
I have 49,000 fields to go through and I have been asked to delete duplicate titles, and some of the titles have different punctuation, which makes it so that the built in excel function - find duplicates - not work. I have attached an example of what I am working with. I am looking for duplicates only in column a. Is there a macro to help do this more quickly? Thank you!