Hi,
I was wondering if anyone had any idea how accomplish this task. I have a large sheet with a lot of duplicate values Id like to remove. I used conditional formatting to highlight the dupes, but the problem is when I delete one it takes Excel a good minute to respond. There are about 1000 dupes so this is too painfully slow to do this way. I have tried turning calculation to manual which helps, but not enough its still too slow. I have tried creating a duplicate sheet -2 and highlighting them on one while deleting on the other. This also helped, but gets confusing because the highlights never go away on the -2 sheet. I would like to know if I can copy and paste the conditional formatting format that highlights them pink and then remove the conditional formatting to be left with the dupes highlighted. Maybe there is some way to sort by the conditional formatting results then i could cluster them and delete all at once? Or if someone has another possible solution to speed things up. Appreciate any help.
I was wondering if anyone had any idea how accomplish this task. I have a large sheet with a lot of duplicate values Id like to remove. I used conditional formatting to highlight the dupes, but the problem is when I delete one it takes Excel a good minute to respond. There are about 1000 dupes so this is too painfully slow to do this way. I have tried turning calculation to manual which helps, but not enough its still too slow. I have tried creating a duplicate sheet -2 and highlighting them on one while deleting on the other. This also helped, but gets confusing because the highlights never go away on the -2 sheet. I would like to know if I can copy and paste the conditional formatting format that highlights them pink and then remove the conditional formatting to be left with the dupes highlighted. Maybe there is some way to sort by the conditional formatting results then i could cluster them and delete all at once? Or if someone has another possible solution to speed things up. Appreciate any help.
Last edited: