LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default How do you have a formula range be determined by the location ofanother cell?

Random data set below for example. Using 1 column and many rows:
A
1) 40
2) 32
3) 42
4) 35
5) 12
....
no data in between
....
25) 39
26) 31
27) 25
28) 14
29) 09

This data will be manipulated by formulas that work on a fixed ($)
range (ie, $A$1:$A$5) at some column to the left. I will be coping
down these formulas and just updating the data in column A. The issue
is that with all the ranges being fixed when I copy down the rows the
ranges are not shifted down. If I removed the $'s everything will
work, but what I'm trying to do requires the fixed ranges (and for my
learning as well). I can find the address of the new range with
address(), but I can't apply it to the formula as it results as a text
in double quotes.
Example:
in cell A24 i can type in the following code:
=address(row(A25),column(A25),1) = $A$25
then the formulas doing stuff I would like to use this address:
=dosomethingwithfixedrange(A24:XX)

Reiteration: I want to find the cell address of a particular cell and
use that address as part of a fixed range in a different cell. Like
telling the formula where to start a range...

Any help will be MOST useful.

Thanks,
Daniel
 
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
Insert # of Rows determined by cell Justin H Excel Discussion (Misc queries) 13 December 6th 07 09:25 PM
Find DMIN in a column range determined by a number in another cell dlbeiler Excel Worksheet Functions 0 October 11th 07 07:09 PM
Saving a pre-determined range of cells as text? [email protected] Excel Discussion (Misc queries) 2 March 27th 07 11:58 PM
Getting a value from a cell that is determined by a formula carl43m Excel Discussion (Misc queries) 3 August 14th 06 06:31 PM
How do I generate a sum, determined by cell color? KFX Excel Worksheet Functions 3 January 2nd 05 12:36 PM


All times are GMT +1. The time now is 02:34 AM.

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

About Us

"It's about Microsoft Excel"