Delete rows takes forever
 

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?

Delete rows takes forever
 

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?

before deleting set calculation to manuell


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Delete rows takes forever
 

I did what you suggested and it's taking 30 minutes and counting.

Delete rows takes forever
 

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.

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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Delete rows takes forever
 

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.

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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2