Ranking Question Listing Same Sheet!

[Guest]

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!

 

[T. Valko]

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

 

[nghl]

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










- 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

 

[T. Valko]

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










- 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