Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
deleting blank rows for up to 60000 rows of data | Excel Programming | |||
Expanding and decreasing data | Excel Discussion (Misc queries) | |||
increasing height of cells without decreasing size of data | New Users to Excel | |||
decreasing # to stop decreasing when <=0 | Excel Worksheet Functions | |||
Deleting rows using key data | Excel Programming |