Hi.
Looking for some help regarding the row function.

I have the following formula:

=LARGE($C$19:$D$24,ROW()-ROW($D$18))

Some data is included here by way of example:

Peter 5000
Mary 7000
Mark 10000
John 2000
James 900

and in the column to the right of that is the formula above which then gives
me a sort using the that formula which it does successfully but I also want
to sort such that I see both the name and the amounts sorted (clearly 2
columns). I can get the amounts to list in order but cannot get the names to
go with them.