Offset--a beginning question

WYTT

New Member
Joined
Mar 6, 2002
Messages
13
Not realy understand when to use Offset function and how to use it, special when combine another function with offset, such as "=sum(offset(rng1, 0, rng2-1)", what does Offset really mean? Thanks a lot
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
On 2002-04-29 13:28, WYTT wrote:
Not realy understand when to use Offset function and how to use it, special when combine another function with offset, such as "=sum(offset(rng1, 0, rng2-1)", what does Offset really mean? Thanks a lot

Did you have a look in Excel's Help file? It's pretty good exposed.

And what is rng1 and rng2 in the formula you mention?
 
Upvote 0
Read Excel Help of Offset function a couple of times, but still have a problem to apply it! in what kind of circumstance should use it? also how to combine offset with other functions?

Rng1 and Rng2 is defined name of two datas. The name can be changed base on your perference.
 
Upvote 0
On 2002-04-29 14:05, WYTT wrote:
Read Excel Help of Offset function a couple of times, but still have a problem to apply it! in what kind of circumstance should use it? also how to combine offset with other functions?

Rng1 and Rng2 is defined name of two datas. The name can be changed base on your perference.

The OFFSET worksheet function has lots of uses. One particular use is constructing dynamic name ranges and similarly when you want to apply functions to ranges that change. I use it a lot myself. See a contrib of mine at

http://www.mrexcel.com/board/viewtopic.php?topic=6611&forum=2

BTW, You didn't tell what rng1 and rng2 stand for!
 
Upvote 0
Thanks a lot.
Rng1 is named for "product range", Rng2 for "choice range". Sorry not clarify it last post
 
Upvote 0
Aladin,

Read your link, it is very helpful. Ask a stupid question, the formula that you used is:

=sum(offset($B$2, match(d2, A:A, 0)-e1-1, 0,E1, 1)

Why $B$2 not $B$1? What is $B$1 and $B$2?

Thanks a bunch!!!!!
 
Upvote 0

Forum statistics

Threads
1,213,564
Messages
6,114,334
Members
448,567
Latest member
Kuldeep90

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