Posted to microsoft.public.excel.worksheet.functions

Seanie

external usenet poster

Posts: 202

Offset Q

Could someone help me figure out the offset function

I have a reference in cell AG2 of =Fig!K10, I want to drag this to AS2
with values of =Fig!K11; =Fig!K12 etc etc

How can I do that without entering all these references manually?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Help with Offset	kazoo	Excel Discussion (Misc queries)	4	August 26th 08 10:24 PM
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul	RyGuy	Excel Worksheet Functions	2	September 28th 07 10:54 PM
Offset Help	Hunter	Excel Worksheet Functions	5	January 26th 07 02:21 PM
offset	Larry	Excel Worksheet Functions	4	May 12th 05 04:10 AM
SUM(OFFSET)?	Mike Fogleman	Excel Worksheet Functions	10	December 29th 04 08:39 PM

All times are GMT +1. The time now is 05:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us