Help with ROW function

[markmcd]

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.

 

[T. Valko]

Names in C19:C24
Numbers in D1924

Enter this formula in F19:

=INDEX(C$19:C$24,MATCH(G19,D$19$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 D1924 then you'll need
different formulas.

 

[HKaplan]

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)

 

[markmcd]

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