Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Rainhard Fischer   on Mar 07 In MS Office Category.

  
Question Answered By: Girja Garg   on Mar 07

If it is just this one spreadsheet and just 2000 rows, it might be
faster to use a spare column to add a repeating sequence of 1 through 5
(as below). This takes a little time, but if you copy the first
sequence and paste, then copy the 2 sequences and paste, then copy the
four sequences and paste, etc...it wouldn't take more than a minute (I
just tried it to be sure).

A B C
A1 1,000.00 1
A2 Completed 2
A3 Misc data  3
A4 Misc Data 4
A5 5
A6 4,500.00 1
A7 Completed 2
A8 Misc Data 3
A9 Misc Data 4
A10 5
A11 1,452.25 1
.
.
.
A2000

Next, figure out which sequence number corresponds to the data you want
to keep (1 in this case), highlight the whole area, apply the
autofilter, and select the data you want by filtering out the other
sequence numbers. You could also select and delete the rows  you don't
want, but you'd better make a copy first.

Share: 

 

This Question has 11 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Deleting Non-consecutive rows in VBA Or get search suggestion and latest updates.


Tagged: