Please. The formula already posted for increasing the row number while dragging across
columns.(=OFFSET($A$1,COLUMN()-1,)
Want to drag down formula in rows, increasing the column letter, using same type of formula with offset?
Please. The formula already posted for increasing the row number while dragging across
columns.(=OFFSET($A$1,COLUMN()-1,)
Want to drag down formula in rows, increasing the column letter, using same type of formula with offset?
is this what you need?
=OFFSET($A$1,row())-1
this row() function return the row number of that cell. you should modify that -1
to adjust the result to acurate number.