Posted to microsoft.public.excel.worksheet.functions

Liam

external usenet poster

Posts: 9

Incremental References

I was wondering if anyone could help:

I would like to make a list referencing cells equidistantly apart:

In sheet 2 i am interested in a value every 40 rows apart and in the other
sheet 1 I would like to make a list of those values every row:

In sheet 1:

A1 =Sheet2!A1
A2 =Sheet2!A41
A3 =Sheet3!A81

and so on...can anyone help?

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 converting a block of cells with Absolute and mixed references to relative references	Vulcan	Excel Worksheet Functions	3	December 13th 07 11:43 PM
Incremental Numbering	Challenged	Excel Worksheet Functions	2	January 18th 07 11:51 AM
Incremental Numbering	fastcar	Excel Worksheet Functions	1	July 12th 06 03:13 AM
incremental counter	cynthiabryant	Excel Worksheet Functions	4	April 3rd 06 05:15 PM
Incremental comparison	olasa	Excel Worksheet Functions	0	June 11th 05 11:57 PM

All times are GMT +1. The time now is 06:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us