Thanks guys. This has done the trick and will save me a heap of work. Cheers
Mark.

"HKaplan" wrote:

On Feb 19, 4:07 pm, markmcd wrote:
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.

Try this:
=INDEX($C$19:$D$23,MATCH(E19,$D$19:$D$23,0),1)