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.

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.

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)

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)