Deleting rows takes forever

G

GWC

a1.a188000 contain values.

I type =if(a2=a1,"dupl","") in b2
I copy that formula and paste it in B2.B188000
I select col b
I do FIND ALL dupl
It finds 12000 cells.
I press the Shift key and click on the first and last cells in the box
I do DELETE rows

Why does Excel "lock up" or take HOURS to delete the 12,000 rows?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete rows takes forever 4
processing time (revised and re-posted) 10
Combine 2 columns in a dynamic range into one 7
Naming non-contigent cells with vba 5
Altered pasting functionality 3
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Deleting backslashs and everything after 3
how to insert serial numbers to rows? 3

Top