I have a large spreadsheet with about 156k rows, that ive divided into rows of 10k. I only want the duplicate values. So, I've performed conditional formatting, and added a filter. Problem is, when trying to filter by color, excel indexes all values of 10k before allowing the drop down to appear to filter by color. This takes 5 minutes each time. Is there a short cut? I'm really trying to save time, and there are 16 spreadsheets now.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
RickXL
MrExcel MVP
- Joined
- Sep 9, 2013
- Messages
- 4,328
Hi,
Are you open to a VBA solution?
If so, what are you trying to do, exactly? Are you trying to find duplicate rows or just duplicate keys in one column? When you have located the duplicates what do you want to do with them - remove them, copy them somewhere else, copy just one of the duplicate values somewhere, copy and remove the originals etc?
Alternatively, VBA would be able to replace, say, a COUNTIF() formula with the result in much less time then it would take to calculate the formulas.
Regards,
Are you open to a VBA solution?
If so, what are you trying to do, exactly? Are you trying to find duplicate rows or just duplicate keys in one column? When you have located the duplicates what do you want to do with them - remove them, copy them somewhere else, copy just one of the duplicate values somewhere, copy and remove the originals etc?
Alternatively, VBA would be able to replace, say, a COUNTIF() formula with the result in much less time then it would take to calculate the formulas.
Regards,
Upvote
0
Similar threads
