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.
Thanks!