Thread
:
Moving Cell Reference after Sorting
View Single Post
#
2
Posted to microsoft.public.excel.newusers
[email protected]
Posts: n/a
Moving Cell Reference after Sorting
You can use 3 as a constant in cojunction with the if statement and
array formula
For example,if cell A1=1,A2=5,A3=3
Instead of referring directly to cell,you can use the constant 3
Tell what you are actually trying to do get precise results
For more,visit and post your questions on
http://groups.google.co.in/group/answers-for-everything
wrote:
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"
Interaction - I **sort** column A so that the data is ascending order,
i.e., A1=1, A2=3, A3=5
Problem - my equation refers only 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). How
how how?
:(((
thanks in advance for your help
steve
Reply With Quote