Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Please. The formula already posted for increasing the row number while dragging across
Want to drag down formula in rows, increasing the column letter, using same type of formula with offset?
is this what you need?
this row() function return the row number of that cell. you should modify that -1 to adjust the result to acurate number.
Required, but never shown