Hi I was wondering if someone could give me a hand on a formula with listing
names and wins totals from top to bottom.

Sheet layout:

Names are in column C12: C44
Wins are in column X12: X44

The listing should appear as follow:
Names in Column AS12: AS12
Wins in column AT12: AT12

Thanks ahead!

This will account for possible ties:

Enter this array formula** in AS12:

=INDEX(C$12:C$44,MATCH(LARGE(X$12:X$44-ROW(X$12:X$44)/10^10,ROWS($1:1)),X$12:X$44-ROW(X$12:X$44)/10^10,0))

Enter this regular formula in AT12:

=INDEX(X$12:X$44,MATCH(AS12,C$12:C$44,0))

Select both AS12 and AT12 and copy down to row 44.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Biff

"Killer" wrote in message
...
Hi I was wondering if someone could give me a hand on a formula with
listing
names and wins totals from top to bottom.

Sheet layout:

Names are in column C12: C44
Wins are in column X12: X44

The listing should appear as follow:
Names in Column AS12: AS12
Wins in column AT12: AT12

Thanks ahead!

On Jun 5, 9:52 pm, "T. Valko" wrote:
This will account for possible ties:

Enter this array formula** in AS12:

=INDEX(C$12:C$44,MATCH(LARGE(X$12:X$44-ROW(X$12:X$44)/10^10,ROWS($1:1)),X$1*2:X$44-ROW(X$12:X$44)/10^10,0))

Enter this regular formula in AT12:

=INDEX(X$12:X$44,MATCH(AS12,C$12:C$44,0))

Select both AS12 and AT12 and copy down to row 44.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Biff

"Killer" wrote in message

...



Hi I was wondering if someone could give me a hand on a formula with
listing
names and wins totals from top to bottom.

Sheet layout:

Names are in column C12: C44
Wins are in column X12: X44

The listing should appear as follow:
Names in Column AS12: AS12
Wins in column AT12: AT12

Thanks ahead!- Hide quoted text -

- Show quoted text -

Hey Biff

I have tried what you have suggested and I'm getting errors
#N/A in both AS12 & AT12

From AS13: AS44 & AT13: AT44 I'm getting this error #NUM!

I only have 4 names with wins right now could that be the problem?

Thanks

wrote in message
oups.com...
On Jun 5, 9:52 pm, "T. Valko" wrote:
This will account for possible ties:

Enter this array formula** in AS12:

=INDEX(C$12:C$44,MATCH(LARGE(X$12:X$44-ROW(X$12:X$44)/10^10,ROWS($1:1)),X$1*2:X$44-ROW(X$12:X$44)/10^10,0))

Enter this regular formula in AT12:

=INDEX(X$12:X$44,MATCH(AS12,C$12:C$44,0))

Select both AS12 and AT12 and copy down to row 44.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Biff

"Killer" wrote in message

...



Hi I was wondering if someone could give me a hand on a formula with
listing
names and wins totals from top to bottom.

Sheet layout:

Names are in column C12: C44
Wins are in column X12: X44

The listing should appear as follow:
Names in Column AS12: AS12
Wins in column AT12: AT12

Thanks ahead!- Hide quoted text -

- Show quoted text -
**********
Hey Biff

I have tried what you have suggested and I'm getting errors
#N/A in both AS12 & AT12

From AS13: AS44 & AT13: AT44 I'm getting this error #NUM!

I only have 4 names with wins right now could that be the problem?

Thanks
**********

Replied via email

Biff