# nth row

1. ### Min between two values without a defined nth range

Hey All, Been working on this for a while and couldn't figure it out, tried offset, and Match/INDEX. I still cant get around the issue of the range not being a consistent nth row. <tbody> 10:00 100% 10:01 95% 10:02 100% 10:03 95% 10:04 92% </tbody> As the above table illustrates the...
2. ### Plotting a graph with every nth cell

Hi guys, I am trying to plot a graph but I have a lot of data. I have 213,792 rows of data but Excel only lets you plot 32,000 data points on a graph. How do I plot every 7th row of data instead? Below is a small look at what my columns look like (and the rows would be filled in of course)...
3. ### Returning Nth day in a certain week each month

Hi All, I have a sheet where i want to enter one row and it then automatically calculates all the dates below it. However the problem I have is that i want it to calculate every nth day in a certain month so not sure what the formula or code is. Eg I have the following table: <tbody> Start...
4. ### inserting multiple rows after nth rows

I am trying to insert 6 blank rows after every 6 rows of data using a macro. I have this code but it just inserts 1 blank row every 6 rows of data. Sub Insert7thRow() Dim rCell As Range, l As Long For Each rCell In Selection l = l + 1 If l Mod 7 = 0 Then rCell.EntireRow.Insert Next...
5. ### Add and calculate very 4th row

I have a spreadsheet that I would like to add a row every 4th row and subtotal the numbers in the columns D-H (last five columns: <TABLE style="WIDTH: 590pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=786 border=0><COLGROUP><COL style="WIDTH: 110pt; mso-width-source: userset...
6. ### How to copy cells to a different worksheet on every nth row

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List"...