The best 3 of the list??? Any function available?

[riverad]

Hi Guys,

As I am needing to do all the organization for a tournament I will need to use a function that is gonna allow me to automatically take the 3 best scros of a list with names and scores.

If this would be the list, i need this to get converted into the list below of just the 3 best persons with the 3 best scores.

Domi	82
Dani	46
Camilo	81
Phillippe	76
Carlos	56
Luna	68
Michael	74
Thomas	71
Mateo	74
Domi	82
Camilo	81
Michael	74

<tbody>
</tbody><colgroup><col><col></colgroup>

	Can anyone please help me to manage to do this with a function so i dont need to search always manually on all lists, but i can just use always the same formula??? Thank you all Regards Domi

<tbody>
</tbody><colgroup><col><col></colgroup>

 

[Jborg]

I think that Phillippe has the third best.....am I missing something??

 

[AliGW]

I would have thought the LARGE function and the OFFSET function combined would do the trick.

 

[FormR]

If this would be the list, i need this to get converted into the list below of just the 3 best persons with the 3 best scores.

Is it possible to have ties? What would you want to happen if there were more than 3 people who tied?

 

[riverad]

Is it possible to have ties? What would you want to happen if there were more than 3 people who tied?

Thanks for asking, there are no ties, its about scores from 0-2000, so there are no ties, in case there would be any ties, i would change it manually =D

TY

 

[FormR]

Thanks for asking, there are no ties, its about scores from 0-2000, so there are no ties, in case there would be any ties, i would change it manually =D

TY

That makes things easier, see if you can adapt the following to your set-up:

Excel Workbook
	A	B
1	Domi	82
2	Dani	46
3	Camilo	81
4	Phillippe	76
5	Carlos	56
6	Luna	68
7	Michael	74
8	Thomas	71
9	Mateo	74
10
11
12
13	Domi	82
14	Camilo	81
15	Phillippe	76
Sheet1

 

[riverad]

That makes things easier, see if you can adapt the following to your set-up:

Sheet1

*	A	B
1	Domi	82
2	Dani	46
3	Camilo	81
4	Phillippe	76
5	Carlos	56
6	Luna	68
7	Michael	74
8	Thomas	71
9	Mateo	74
10	*	*
11	*	*
12	*	*
13	Domi	82
14	Camilo	81
15	Phillippe	76

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 88px;"><col style="width: 64px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula A13 =INDEX($A$1:$A$9,MATCH(B13,$B$1:$B$9,0)) B13 =LARGE($B$1:$B$9,ROWS($B$13:$B13)) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

I tried to use this form, it wouldnt work, somehow

It says the formula is wrong,

I cannot use the , inside the formula and then write MATCH, somehow it doesnt work... im working on 2010 version, and ive tried to mix it up and use ; and everything, but it wont work =( any other ways to do this??

Plase Help!!!

 

[FormR]

Hi,

Try to change the ,'s to ;'s
Like so..
A13 =INDEX($A$1:$A$9;MATCH(B13;$B$1:$B$9;0))
B13 =LARGE($B$1:$B$9;ROWS($B$13:$B13))

Let us know if you still have problems.

 

[riverad]

Hi Guys,

I tried again, with the ; and also putting a ) after the a9 but it would'nt work.

any other ways to do this?

 

[FormR]

There is an example file here:

https://www.dropbox.com/s/ge10kqd706u96bz/770651-2.xlsx

Does this help?