If you have heard of or used Conditional Formatting on Excel you might have guessed what I am talking about. But there are better ways to get the task done than involving yourself in this drudgery, right? We will discuss one such trick today. Some people take up to using the find feature. If you start sorting it manually, you can spend your day scrolling up and down the sheet without actually achieving anything. Of course there’s a Remove Duplicates option that Excel provides but that only facilitates bulk removal of duplicates from specific columns or rows and doesn’t let you have a lot of control on how the data should be removed.
Trust me, finding and getting rid of the duplicates is a challenging task. The greatest problem that I frequently come across in such cases is repetition and duplication of data. And when that happens it becomes really difficult to manage the document.
They could extend to hundreds and thousands of data rows.
