| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Refering a cell
Dear all Excel Gurus,
Suppose I want to access the value of cell a30. Therefore in formula bar I should write: "=$a$30". Now suppose this '30' comes from other calculation like : "=count(B1:B30) Is there is procedure to directly write "=count(B1:B30)" instead the value 30 like: "=$a$count(B1:B30)"? I tried with this syntax but got error. I am looking for an alternative of that. If anyone give me any suggestion it would be very helpful for me. Thanks, Arun Hyderabad, INDIA |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Refering a cell
=index(a:a,count(b1:b30))
may work for you. Arun Kumar Saha wrote: Dear all Excel Gurus, Suppose I want to access the value of cell a30. Therefore in formula bar I should write: "=$a$30". Now suppose this '30' comes from other calculation like : "=count(B1:B30) Is there is procedure to directly write "=count(B1:B30)" instead the value 30 like: "=$a$count(B1:B30)"? I tried with this syntax but got error. I am looking for an alternative of that. If anyone give me any suggestion it would be very helpful for me. Thanks, Arun Hyderabad, INDIA -- Arun Kumar Saha -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Refering a cell
Here's a WILD guess..
=INDIRECT("a"&A30) "Arun Kumar Saha" wrote: Dear all Excel Gurus, Suppose I want to access the value of cell a30. Therefore in formula bar I should write: "=$a$30". Now suppose this '30' comes from other calculation like : "=count(B1:B30) Is there is procedure to directly write "=count(B1:B30)" instead the value 30 like: "=$a$count(B1:B30)"? I tried with this syntax but got error. I am looking for an alternative of that. If anyone give me any suggestion it would be very helpful for me. Thanks, Arun Hyderabad, INDIA -- Arun Kumar Saha |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| autofill with one part of the formula refering to a constant cell | Excel Discussion (Misc queries) | |||
| Refering to Cells | Excel Worksheet Functions | |||
| Refering to an empty cell | Excel Discussion (Misc queries) | |||
| Refering to a tab using data from a cell | Excel Worksheet Functions | |||
| "criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
Linear Mode
