| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Equation to refer to data value(s) and not the cell??
hi, i'm trying to have a cell reference in an equation following a
moving data point ... Assumption #1 - column A has data A1=1, A2=5, A3=3 Assumption #2 - column B has an equation referring to the "3" in A3 Goal - to have my equation follow the data point "3" Initially - my equation refers to cell A3 (where the value "3" is located) Interaction - I **sort** column A so that the data is ascending order, i.e., A1=1, A2=3, A3=5 Problem - my equation still refers to cell A3 (i.e., value is now 5, originally was 3). I want the equation to refer to wherever my data point went (i.e., to refer to whatever cell the 3 is sorted to, in this case A2). Corollary - if i change the data point e.g., to 7, then re-sort, i'd like the equation to automatically refer to the 7, no matter where it's re-sorted to It is possible to have an equation refer to a moving data point or cell? How to? Thanks in advance, Steve |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
Equation to refer to data value(s) and not the cell??
Hi!
What's your formula look like? What's the significance of the "data point"? Biff wrote in message oups.com... hi, i'm trying to have a cell reference in an equation following a moving data point ... Assumption #1 - column A has data A1=1, A2=5, A3=3 Assumption #2 - column B has an equation referring to the "3" in A3 Goal - to have my equation follow the data point "3" Initially - my equation refers to cell A3 (where the value "3" is located) Interaction - I **sort** column A so that the data is ascending order, i.e., A1=1, A2=3, A3=5 Problem - my equation still refers to cell A3 (i.e., value is now 5, originally was 3). I want the equation to refer to wherever my data point went (i.e., to refer to whatever cell the 3 is sorted to, in this case A2). Corollary - if i change the data point e.g., to 7, then re-sort, i'd like the equation to automatically refer to the 7, no matter where it's re-sorted to It is possible to have an equation refer to a moving data point or cell? How to? Thanks in advance, Steve |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
Equation to refer to data value(s) and not the cell??
See responses to your other post in .newusers
(Pl do not multi-post) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a cell refer to range name/array of data previously set? | Excel Discussion (Misc queries) | |||
| MAKING THE FOLLOWING EQUATION DISPLAY A BLANK CELL IF NO DATA INPU | Excel Discussion (Misc queries) | |||
| Equation to refer to data value(s) and not the cell?? | Excel Discussion (Misc queries) | |||
| How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
| Q: Best way to take data from VBA into graphs without writing data to worksheets? (Can a named range refer to an array in memory only?) | Excel Programming | |||
Linear Mode
