Please Explain Offset

spcalan

Well-known Member
Joined
Jun 4, 2008
Messages
1,247
Can someone please explain the Offset formula?

I have seen it used in many different ways, but do not understand the functionality of it.

Thanks in Advance.
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
Try this:

Click on Help in the main menu, then on Contents and index, type in Offset and enter.

If, after reading the display there, you still have questions, post each one clearly, with reference to that Help information, and we will certainly be able to help you.
 

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,454
spcalan,
I'm not completely sure what you mean by not 'understanding the functionality', but here's a quick example that may help.
Enter something into cell C1.
Then in another cell somewhere, enter the formula: =OFFSET(B1,0,1)
Translated, this means "Display the value in the cell that is offset 0(zero) rows down and 1(one) column to the right of B1."

Now, it's usefulness doesn't seem apparent when used this way (after all, if you know how many columns & rows to offset from a specified cell like B1, it would be easy enough to simply refer to the cell you're after) but if you were to specify an offset from a named range for example, now it's usefulness becomes a bit more obvious.

Beyond that, Ralph's suggestion to check out the help file is always a good idea.

Hope it helps.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,421
Messages
5,596,033
Members
414,039
Latest member
southike

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
Top