I was running a report from another program to an excel spreadsheet. In doing so, I've noticed multiple duplicate entries. I have nearly 5000 lines to go through.
Does Excel recognize duplicate entries and allow them to be deleted or merged in one fell swoop? If so, please tell me how.