Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Excel Formula using relative position of cells in two different worksheets
I want to know how a certain Excel formula would be written.
Excel formulas reside in cells computing the value of the cell content. A given formula can be entered in an entire column, producing different values in each cell in the column in which the one given formula is entered. The desired formula would, based upon the distance in worksheet A of a given cell G that the desired formula resides in from a starting point cell S in worksheet A, reference a cell R in worksheet B, that is a certain distance from a starting point cell BS in worksheet B, and use the value in the referenced cell BS in worksheet B to produce a value for the given cell G in worksheet A. Definition Distance: a cell can be a given number of rows away from a cell in its own column; a cell can be a given number of columns away from a cell in its own row. Help sections do not seem to answer the two basic questions: 1 Is the software able to do a given thing? 2 How is the given thing to be done? Time is wasted simply determining if a software can even do something in the first place. |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
Excel Formula using relative position of cells in two different wo
David,
You can use columns() and rows() to work out where cells are located. It is a little difficult to understand what you want may be an example would help -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "David Virgil Hobbs" wrote: I want to know how a certain Excel formula would be written. Excel formulas reside in cells computing the value of the cell content. A given formula can be entered in an entire column, producing different values in each cell in the column in which the one given formula is entered. The desired formula would, based upon the distance in worksheet A of a given cell G that the desired formula resides in from a starting point cell S in worksheet A, reference a cell R in worksheet B, that is a certain distance from a starting point cell BS in worksheet B, and use the value in the referenced cell BS in worksheet B to produce a value for the given cell G in worksheet A. Definition Distance: a cell can be a given number of rows away from a cell in its own column; a cell can be a given number of columns away from a cell in its own row. Help sections do not seem to answer the two basic questions: 1 Is the software able to do a given thing? 2 How is the given thing to be done? Time is wasted simply determining if a software can even do something in the first place. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to macro to relative position | Excel Discussion (Misc queries) | |||
Excel Formula using relative position of cells in two different worksheets | Excel Discussion (Misc queries) | |||
Excel Formula using relative position of cells in two different worksheets | Excel Worksheet Functions | |||
Create cell formula from a relative position | Excel Programming | |||
Relative Position in VBA Array | Excel Programming |