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

Deleting decreasing data and naming rows.
 

Hi Ben,

I'd like to confirm a couple of things.

You say name cell A of selected row as "2nd Set" etc. Do you mean nameing
the cell as in defined names or simply inserting "2nd set" in the cell in
column A? Also will Set 1, Set 2 suffice because while not impossible, it is
a bit hard to include the suffix to numbers.

Delete Row B:H and shift row up. If you do this then they will be all out of
sync with column A. Do you mean delete the entire row?

--
Regards,

OssieMac


"BenSeekingHelp" wrote:

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

Deleting decreasing data and naming rows.
 

Hi again Ben,

I am sure we can do what you want. Am I correct in assuming that all groups
of data across the worksheet have 8 columns and the 3rd column is where you
want to delete the rows?

How do you want to tell the system which column the particular data set
starts? My suggestion is an input box that asks you to select the first
column of the set to start processing.

I see that you also have another thread relating to this project and it is
starting to look like an extended project. If you want to get yourself a
Hotmail address (or any other provider of email addresses) that you can
abandon later if you start getting spam and post that address then I will
reply and you can then communicate with an attached copy of your workbook.

If you post an email address then do it something like the following example
so that people using code to troll the internet for email addresses are not
so likely to pick it up but I will be able to decipher it.

myaddress with provider hotmail and then the usual com

--
Regards,

OssieMac