i have a set of around 20000 different names in which there are a many duplicates, i need to delete them all at once, and i need to create a macro for it. I know how to use conditional formatting to highlight all the duplicate cells but how do i delete all of them along with the adjacent cell to its right side?
i used one technique where it identifies the color of the cell and deletes it but that is only working if i have actually colored the cell but not when its colored bcoz of conditional formatting, so please help as i get more than 20 such files every week and its very difficult to maintain such huge database without using excel.
Bookmarks