nth row

  1. V

    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. D

    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. A

    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. E

    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. B

    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. D

    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"...

Some videos you may like

This Week's Hot Topics