Offset--a beginning question

WYTT · Apr 29th, 2002, 02:28 PM

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

Aladin Akyurek · Apr 29th, 2002, 02:51 PM

Quote:

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?

WYTT · Apr 29th, 2002, 03:05 PM

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.

Aladin Akyurek · Apr 29th, 2002, 03:19 PM

Quote:

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/viewtop...c=6611&forum=2

BTW, You didn't tell what rng1 and rng2 stand for!

WYTT · Apr 30th, 2002, 07:40 AM

Thanks a lot.
Rng1 is named for "product range", Rng2 for "choice range". Sorry not clarify it last post

WYTT · Apr 30th, 2002, 08:14 AM

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!!!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 02:28 PM	#1
WYTT New Member Join Date: Mar 2002 Posts: 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

Apr 29th, 2002, 03:05 PM	#3
WYTT New Member Join Date: Mar 2002 Posts: 13	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.

Apr 30th, 2002, 07:40 AM	#5
WYTT New Member Join Date: Mar 2002 Posts: 13	Thanks a lot. Rng1 is named for "product range", Rng2 for "choice range". Sorry not clarify it last post

Apr 30th, 2002, 08:14 AM	#6
WYTT New Member Join Date: Mar 2002 Posts: 13	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!!!!!