How to use offset properly

**katz2eric** · 07-14-2016, 06:32 AM

Hi, I'm trying to make a formula where I can skip rows and columns. In the picture you can see the formula I'm trying to use, which is summing 7 consecutive cells and dividing by 50, then copying the formula over 1 and summing the next consecutive 7 cells and dividing by 50, doing that through 28 cells, then bringing the formula down to containers 2.1-2.4, and running the same formula for 6 cells below for the next empty shells row. Any idea on how to do this?Screen Shot 2016-07-14 at 1.24.05 PM.png

**Olly** · 07-14-2016, 06:36 AM

An image is impossible to work from.

Attach a sample workbook instead. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**katz2eric** · 07-14-2016, 07:10 AM

Ok, i've just tried to attach the files

**xlnitwit** · 07-14-2016, 07:34 AM

Hi,

I would recommend using INDEX rather than OFFSET for this. I have attached an example workbook which has an additional row and column to store the row and column references required for the index formulas. You can hide these for display purposes.

**katz2eric** · 07-15-2016, 12:11 PM

thanks for the advice!

How to use offset properly

LinkBack

Thread Tools

Rate This Thread

Display

How to use offset properly

Re: How to use offset properly

Re: How to use offset properly

Re: How to use offset properly

Re: How to use offset properly

Thread Information

Users Browsing this Thread

Similar Threads

Select offset variable offset cells

Using OFFSET function to return the value from another cell with row and column offset

OFFSET function not working properly.

function similar to offset to offset the offset

offset function that I cannot get to work properly

Reformatting - insert formula with offset, then offset to next cell

IF and OFFSET: how to OFFSET only if cell has a value in it (follows previous post)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions