display the cell value in the next 33rd cell

=?Utf-8?B?Ym1uam5hMjAxOQ==?=

Guest

Posts: n/a

16th Sep 2006

I need some help with writing a 'search & display' formula:

Scenario:
cell A9 has a value of $4600
-> set cell T2 to '=A9'

Question: what formula do I put in T3 if I want it to return the value in
cell A42 (basically, every 33rd cell from a range of cells). This is for a
monthly report where the starting cell is not always 'A9', and the locations
of the 'next 33rd cell' varies from month to month...

thanks!

« Inserting columns & rows in worksheets | Creating summary table from detail table »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
display text in one cell as a number in an adjacent cell in excel	=?Utf-8?B?RGVubm8=?=	Microsoft Excel New Users	1	16th Nov 2006 05:13 PM
display the cell value in the next 33rd cell	=?Utf-8?B?Ym1uam5hMjAxOQ==?=	Microsoft Excel Worksheet Functions	6	25th Sep 2006 05:23 PM
How to click on a cell and have the content of the cell display in a different cell	marin_michael@yahoo.ca	Microsoft Excel Worksheet Functions	0	6th Jun 2006 03:05 PM
collecting cell data from every 33rd row	=?Utf-8?B?UmViZWNjYQ==?=	Microsoft Excel Worksheet Functions	4	22nd Jul 2005 03:42 PM
Shortcut key to display change the display from displaying cell values to cell formulae	=?Utf-8?B?QUEyZTcyRQ==?=	Microsoft Excel Programming	3	14th Sep 2004 12:07 PM