non consecutive cells

  1. 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...
    • leknuok
    • Thread
    • average non consecutive cells non continuous non sequential cells pattern
    • Replies: 1
    • Forum: Excel Questions
  2. Prevost

    Assign multiple non-continuous cells to desired cells

    Hi There. I believe I had this working last week but I cannot remember what I had (or if it actually worked as I wanted it). I want to assign cell values in a non-continuous range, to other cells in a non-continuous range. The code should show exactly what I want to do. I want the values of...
  3. M

    Reporting Macro using 3 reference cells in a range

    Hello, I am currently working on a macro that would work with a spreadsheet containing people's information. As an example which is compatible with the code below, let's assume that the worksheet the formula is looking at, in column A will have a person's Location. Column B will have information...

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