Posted to microsoft.public.excel.programming

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

Reference a row programmatically

hi,

Am Wed, 24 Jul 2013 07:25:05 -0700 (PDT) schrieb RVic:

76
57
21
7
15

and I want B1 to reference A1, B2 to reference A5, B3 to reference A9 (I am incrementing by 4) how do I specify this in the formula for column B?

try in B1:
=INDEX($A$1:$A$100,(ROWS($1:1)-1)*4+1)
and copy down

Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

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
Setting VBA reference programmatically	Nicholas Dreyer	Excel Programming	3	October 19th 06 03:49 PM
programmatically Set Reference to Library	Todd uttenstine	Excel Programming	6	April 30th 04 10:55 AM
Programmatically Add Reference`	keepitcool	Excel Programming	1	September 16th 03 05:30 PM
Programmatically Add Reference`	Jean-Paul Viel	Excel Programming	0	September 16th 03 02:23 PM
Can i set a reference programmatically?	Tom Ogilvy	Excel Programming	1	August 19th 03 04:24 PM

All times are GMT +1. The time now is 09:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us