Excel taking too long

[Interesting Ian]

Hi,

I currently have 160,000 rows of data. There's only 7,000 rows I want to
keep which are on every 22nd row. So I used that "mod" command and am
displaying the remaining 153,000 rows. I highlighted them all and pressed
delete. However that was 3 hours ago and the curser is still doing its
endless circling!! Nor does there appear to be any indication of how longer
excel will take to merely delete some rows!

The question I want to ask is there any quicker way of doing this? I'm just
wondering if it is worth my while to press alt ctrl and delete and end the
process and do it some other way. Trouble is I didn't press save before
attempting to delete these rows.

Why does excel take such an extraordinarily long time to do anything?? I
have 6GB of RAM and a quad core. Does no good! Is there any better
spreadsheet software out there?

 

[Interesting Ian]

Hi,

I currently have 160,000 rows of data. There's only 7,000 rows I want to
keep which are on every 22nd row. So I used that "mod" command and am
displaying the remaining 153,000 rows.

Using the filter thingy that is.

 

[Pete_UK]

As you only wanted to keep 7000 rows, it would have been quicker to
have copied those to another sheet (by using the filter in the
opposite way, or by using a formula to bring the data across from
every 22nd row and then fixing the data), and then you could just
delete the first sheet.

Hope this helps.

Pete

 

[Dave Peterson]

I would add that helper column with the =mod() formula in it.
But then I would convert that column to values (paste special values)

And then I would sort the data by that column and then I could the block of data
that I want (or delete the top and bottom and keep the middle -- depending on
what that =mod() formula returned).

In fact, I might even change the =mod() formula to be something like:

=if(mod(row(),22)=17,"keep","delete")
Just so the data sorts into exactly two groups.

 

[The_Giant_Rat_of_Sumatra]

The other thing is that whenever possible MARK only the region that
contains data as opposed to marking entire rows as the new column limit
in 2k7 and up makes that a much larger data set typically.

So mark and copy and paste in into a new sheet, but only mark the data
set, not the entire row. In other words, leave the blank columns out.

 

[Proteus IIV]

  The other thing is that whenever possible MARK only the region that
contains data as opposed to marking entire rows as the new column limit
in 2k7 and up makes that a much larger data set typically.

  So mark and copy and paste in into a new sheet, but only mark the data
set, not the entire row.  In other words, leave the blank columns out.

ACCEPT THE FACT THAT YOU MSN SOFTHEADS ARE NOTHING BUT IDEA STEALING
TWISTED TALE TROLLS AND YOU HAVE SUCKED SINCE YOU DUPED YOURSELVES
INTO VISTA THE WINDOWS
THEN YOU GOT BING BANGED SEARCHING UP YOUR COLLECTIVE BUMS
SPREADSHEET YOUR BEHIND WIDE YOUR GLORY DAYS ARE OVER
YOU FILTHY RAT AND STOP HARASSING USENET WITH YOUR ANGRY CRYING
GO DROWN IN A GIANT SEWER YOU FREAK
OTHERWISE
YOU ARE JUST GETTING YOUR HEAD CHOPPED OFF IN AN EVEN BETTER RAT TRAP
YOU DIRTY LOW DOWN HACK
FLEE WHILE YOU CAN


I AM PROTEUS