LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 407
Default Offset function

I have values in row 2, say in columns A through Z (so cells A2 thru Z2)
for values that happen in months 1 thru 26, respectively. In row 3, I would
like to see those same values appear, but delayed by "N" months. Let's say
N is the value of cell A1, a value that may change from time to time. So,
for example, if cell A2 has the value 4 in it, and if N=3, I would like cell
D3 to have the value 4 in it also.

I have seen this done with an offset function, but it doesn't seem to be
working for me. Can someone tell me what my equations in row 3 need to be?
Do I need to use a range name?

Thanks!
Dean


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Offset function Eva Excel Worksheet Functions 12 November 12th 09 11:32 PM
OFFSET Function April Excel Worksheet Functions 1 July 16th 09 12:36 PM
large function result as reference for offset function Z Excel Discussion (Misc queries) 1 May 5th 09 12:55 AM
XL2002 - OFFSET function and LARGE function Trevor Williams Excel Worksheet Functions 3 March 3rd 08 01:40 PM
Offset function with nested match function not finding host ss. MKunert Excel Worksheet Functions 1 March 21st 06 10:46 PM


All times are GMT +1. The time now is 01:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"