non sequential cells

  1. D

    Non sequential read and write with arrays

    I am attempting to pull data into 3 arrays. 2 arrays from sheet one, "Summary", and 1 arrays from sheet two, "Detail". After pulling the arrays, I will compare Array1, "Project Name" on sheet Summary to Array3, "Project Name" from the detail Sheet. If the values match, I need to take he...
  2. L

    Help with Continuous Patterns in Non Sequential Cells

    I need help with creating a pattern with the average formula. I'm brand new to this site so I tried a search, but didn't have any luck finding what I wanted. This is the formula I'm currently using: =IFERROR(AVERAGE(B19,B32,B45,B58,B71),"") The IFERROR is for the cells that can't divide by 0...
  3. D

    Sum Every Other Cell -Ignoring Errors in Range

    Hi, I am unable to come up with a simple formula that will sum every other cell in a row AND ignore any error messages that may occur. Numbers are always positive. For this case: <TABLE style="WIDTH: 384pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=640 border=0...
  4. B

    Copy cells

    I am trying to copy cells in a non sequential order: For Example, I have the following sheet: In Sheet 1, I have A B C D 1 A 2 B 3 C In Sheet 2, I have A 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 I am trying to create in Sheet 1 a formula that allows me to have this result: A B C D 1 A 1...

Some videos you may like

This Week's Hot Topics