How to modify the following formula to expand instead of repeat

[blueray]

I have formula like bellow:

=0 &"'s Friend is "& 10-0
=1 &"'s Friend is "& 10-1

The output is like:

0's Friend is 10
1's Friend is 9

When I select the two rows and drag, it repeat the two lines

0's Friend is 10
1's Friend is 9
0's Friend is 10
1's Friend is 9
0's Friend is 10
1's Friend is 9
....

instead of:

0's Friend is 10
1's Friend is 9
2's Friend is 8
....

How can i get the expected output.

[fpy]

same Autofill cells with a formula Sequence - #2 by Lupp

[fpy]

and for the interesting fun …

[karolus]

Start with formula:

=ROW(A1)-1 & "'s Friends is " & 11- ROW(A1)

and pull down across 11 Rows