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

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top