linear increase in a function's k parameter when copying across cells in a column

Hi there,
couldn't get an answer to this question by searching into solved problems in the forum, maybe I didn't formulate the query properly, but anyway:
I am using the LARGE formula to pick the k-th value in a grid (A1:Z100) of values, but I am reiterating this for the k+1, ..., k+n-th value by copy/paste of the query =large($A1:$Z100,k) in the next cell of the column and manually entering 2, 3, ..., n in place of k
Is there a way to avoid the bore of manually entering k and have excel do this automatically, as happens when getting a series of progressive numbers by copy/paste of the cells in a 1,2,3 series?
Cheers
Alfredo

hi,
have you tried =large($A1:$Z100,row()) ?
AL

or row() MINUS or PLUS something

Thanks for the swift reply, but the row command does not seem to work

can you send the file, showing what you have and what you want , so that I can look at it better ?
thks.
AL

Here's an example file.
Cheers,
Alfredo

large_k+1.xlsx

hi,
here attached the file where I'm proposing 2 solutions, depending on whether you want to specify k value in column G or not.
hope this helps.
AL

Thanks a lot!!!
Cheers
Alfredo