| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ADDRESS Function as cell ref in equation
The ADDRESS function returns a text string of a cell location; i.e. R17. How
can I use this output as a cell reference in an equation? I keep getting #VALUE! errors. -- Thanks, TheHat |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ADDRESS Function as cell ref in equation
Put it inside =indirect().
=indirect("a1") will always point to A1 =indirect(a1) will point to the cell whose address is in A1. =indirect(address(.... TheHat wrote: The ADDRESS function returns a text string of a cell location; i.e. R17. How can I use this output as a cell reference in an equation? I keep getting #VALUE! errors. -- Thanks, TheHat -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ADDRESS Function as cell ref in equation
Dave - This did solve the VALUE error problem; but the output is an absolute
"0". The resultant value of the new equation is zero. I still can't get a cell reference that can be used in an equation. I guess the better question is, how can I write an equation that will determine the cell the equation is in, and use that cell as a reference in another equation? -- Thanks, TheHat "Dave Peterson" wrote: Put it inside =indirect(). =indirect("a1") will always point to A1 =indirect(a1) will point to the cell whose address is in A1. =indirect(address(.... TheHat wrote: The ADDRESS function returns a text string of a cell location; i.e. R17. How can I use this output as a cell reference in an equation? I keep getting #VALUE! errors. -- Thanks, TheHat -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ADDRESS Function as cell ref in equation
Post the *exact* formula you tried.
-- Biff Microsoft Excel MVP "TheHat" wrote in message ... Dave - This did solve the VALUE error problem; but the output is an absolute "0". The resultant value of the new equation is zero. I still can't get a cell reference that can be used in an equation. I guess the better question is, how can I write an equation that will determine the cell the equation is in, and use that cell as a reference in another equation? -- Thanks, TheHat "Dave Peterson" wrote: Put it inside =indirect(). =indirect("a1") will always point to A1 =indirect(a1) will point to the cell whose address is in A1. =indirect(address(.... TheHat wrote: The ADDRESS function returns a text string of a cell location; i.e. R17. How can I use this output as a cell reference in an equation? I keep getting #VALUE! errors. -- Thanks, TheHat -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ADDRESS Function as cell ref in equation
Not an answer but a question in the same line of thought...
Say the SS is incrementing to the next number in the row, but the rows are grouped in sets of rows. Each set(group) of rows is numbered. A valid equation would consist of: =(MAX($A$10:$A20)+1) This would be placed in cell A21 and would "get" the largest number in the range of rows from 10 through 20 and increment to the next number. Thus correctly numbering each set. This will work for a predefined SS where the lines can be deleted and the groups of rows will retain the correct numbering... I desire to make this a bit more autononous w/o the use of a macro. The purpose being, adding a set of rows w/o having to bother with readjusting the equation. And in some cases the desire to not execute macros in the SS for the purposes of security ;). Say with an equation like: =(MAX($A$10:(ADDRESS((ROW()-1),1))))+1) but EXCEL doesn't like the syntax that is being used and it isn't clear what should be corrected. On Mar 21, 1:00*am, "T. Valko" wrote: Post the *exact* formula you tried. -- Biff Microsoft Excel MVP "TheHat" wrote in message ... Dave - This did solve the VALUE error problem; but the output is an absolute "0". *The resultant value of the new equation is zero. *I still can't get a cell reference that can be used in an equation. *I guess the better question is, how can I write an equation that will determine the cell the equation is in, and use that cell as a reference in another equation? -- Thanks, TheHat "Dave Peterson" wrote: Put it inside =indirect(). =indirect("a1") will always point to A1 =indirect(a1) will point to the cell whose address is in A1. =indirect(address(.... TheHat wrote: The ADDRESS function returns a text string of a cell location; i.e. R17. *How can I use this output as a cell reference in an equation? *I keep getting #VALUE! errors. -- Thanks, TheHat -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assign the cell address with a function | Excel Worksheet Functions | |||
| Function that Returns address of that cell? | Excel Worksheet Functions | |||
| Function to find the address of a cell | Excel Worksheet Functions | |||
| How do I use a function to return the address of a cell? | Excel Worksheet Functions | |||
| How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
Linear Mode
