Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete rows takes forever
I did what you suggested and it's taking 30 minutes and counting.
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code Takes Forever to Run - Why? | Excel Programming | |||
Find Replace takes forever | Excel Discussion (Misc queries) | |||
ActiveSheet.Paste takes FOREVER!! | Excel Programming | |||
Excel takes forever to shut down | Excel Programming | |||
Calculating Time in XP takes forever | Excel Discussion (Misc queries) |