Delete rows takes forever

  • Thread starter Thread starter GWC
  • Start date Start date
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 it take HOURS to delete the 12,000 rows?
 
Hi,

Am Tue, 19 Nov 2013 11:06:15 -0800 (PST) schrieb 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 it take HOURS to delete the 12,000 rows?
Click to expand...

before deleting set calculation to manuell


Regards
Claus B.
 
Hi,

Am Tue, 19 Nov 2013 11:45:56 -0800 (PST) schrieb GWC:
I did what you suggested and it's taking 30 minutes and counting.
Click to expand...

then go another way:
Write in B2
=IF(COUNTIF($A$2:$A$188000,A2)>1,"Duplicate","")
and copy down.
Then filter column B for "Duplicate" and delete contents of all visible
cells. Select column A and sort to eliminate the blank cells.


Regards
Claus B.
 
Hi again,

Am Tue, 19 Nov 2013 11:45:56 -0800 (PST) schrieb GWC:
I did what you suggested and it's taking 30 minutes and counting.
Click to expand...

if you use xl2007 or later you can also try it via Data => Remove
duplicates.
Or (with all versions) you can filter with advanced filter without
duplicates to another column.


Regards
Claus B.
 
Back
Top