delete rows in increments based on values in a column

talla

New Member
Joined
Apr 16, 2019
Messages
4
Hello,

I have a sheet (many sheets!) with 2 columns, 50001+ rows.
Row 1 is column headers.
Column 1 values are numbers in increments of 1 starting at 200.
I need to remove groups of rows, in various increments, based on the value in column 1.

For example,
If the value in column 1 is between 500 and 600, leave rows with column 1 values in increments of 5.
So, remove all rows except 500, 505, 510, 515, 520, etc.


If the value in column 1 is between 600 and 1200, leave rows with values in increments of 100.
So, remove all rows except 600, 700, 800, etc.


And so on - more of the same with different ranges and increments.

In the end, I need to leave the row with a value of 45559 and delete all remaining rows.

I'll greatly appreciate any help in writing a macro to do this.

Thank you!
T
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,223,896
Messages
6,175,265
Members
452,627
Latest member
KitkatToby

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top