How can i increment a formula in excel?

Help Forum
1

Need to Increment the formula according to the number of lines

2

@Soudios -

3

@prasath17

Thank you but in this example, i need to write the 1st row and the last one.
In my case the number of row can change, how can i do ?
Auto Fill Range.zip (9.3 KB)