Posts

Showing posts with the label OFFSET Formula

Previous row values - OFFSET

The OFFSET Excel formula is quite useful when we need to access the values of previous or next rows. Syntax =Offset(currentcell,row,cols) Example :  =Offset(A10,-1,0) Returns the value of Cell A9.