I was to find minimum value from the 2nd cell below the active cell to the 10th cell below.
lets say active cell e.g. its b2
then i want to find minimum value from cell b4 to b14
but the active cell will be different all the time and so i want an excel formula which can understand the current row and calculate based on that
i tried the formula
but this does not work.
can any one guide me in this....
if u dont understand my query pls ask whatever clarity is needed.