excel - function which takes address() and gives value -


I want to create a cell equal to the cell above it.

When I write > 

  = Address (line () - 1; column ())   
 This is just the cell above (For example, it writes $ B $ 1 for B2)  
 Is there a function that writes the address and adds value?   
 
 
 Try to use the function to offset the line -1 by the cell for example Paste the formula in cell A2 and it will return the value of A1:  
  = OFFSET (A2, -1)   
 if If you really want to keep your current address method, then you want to put it inside such a function:  
  = INDIRECT (ADDRESS (ROW () - 1, COLUMN ()) < / Code>

Comments

Post a Comment