LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Deleting decreasing data and naming rows.

I have a list of data in columns B:H that I want to delete specific values
within.
The data in column C is in the format example below. The numbers are not
necessarily whole numbers or increasing or decreasing in even amounts. The
example is simplified as each data set can have thousands of streams where
the data increases then decreases, repeating again and again in a constant
stream. I want a data set of numbers that are continually increasing or
restarting the sequence with no decreasing values or zeros.

Searching column C, when the next cell is < the preceeding cell, select
Rows B:G. Name cell A of selected row "2nd set". Continue selecting rows
B:H until the value in column C is = 1. Delete and shift up the selected
section. Restart logic starting at row that was named 2nd set.

Format Example: Column C data:
1
3
7
9
7 Name row in cell A "2nd set" and Delete Row B:H and shift row up
3 Delete Row B:H and shift row up
0 Delete Row B:H and shift row up
0 Delete Row B:H and shift row up
1.4
2
3.8
4
2 Name row in cell A "3rd set" and Delete Row B:H and shift row up
0 Delete Row B:H and shift row up
0.1 Delete Row B:H and shift row up
2
6
10
etc.

Huge Thank You! to anyone that can help

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
deleting blank rows for up to 60000 rows of data gbpg Excel Programming 4 December 27th 09 08:37 PM
Expanding and decreasing data CDH Excel Discussion (Misc queries) 1 August 14th 08 07:40 PM
increasing height of cells without decreasing size of data joaniep New Users to Excel 1 July 19th 08 07:02 PM
decreasing # to stop decreasing when <=0 Ken Excel Worksheet Functions 1 March 4th 07 07:02 AM
Deleting rows using key data shylu Excel Programming 1 September 13th 04 11:37 AM


All times are GMT +1. The time now is 04:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"