Names in C19:C24
Numbers in D19:D24

Enter this formula in F19:

=INDEX(C$19:C$24,MATCH(G19,D$19:D$24,0))

Enter this formula in G19:

=LARGE($D$19:$D$24,ROWS(G$19:G19))

Select both F19 and G19 and copy down as needed.

Note that if there are duplicate numbers in D19:D24 then you'll need
different formulas.


--
Biff
Microsoft Excel MVP


"markmcd" wrote in message
...
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.