I have… what would seem to be a basic excel question. I have a series of text data… I need to find the duplicates. I know that excel 2007 has an option to remove all duplicates… however, is there away to highlight any duplicates in a series of data without having to delete them?
Thank you in advance for your time and help.