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.

[TABLE="width: 263"]
<tbody>[TR]
[TD]Domi[/TD]
[TD="align: right"]82[/TD]
[/TR]
[TR]
[TD]Dani[/TD]
[TD="align: right"]46[/TD]
[/TR]
[TR]
[TD]Camilo[/TD]
[TD="align: right"]81[/TD]
[/TR]
[TR]
[TD]Phillippe[/TD]
[TD="align: right"]76[/TD]
[/TR]
[TR]
[TD]Carlos[/TD]
[TD="align: right"]56[/TD]
[/TR]
[TR]
[TD]Luna[/TD]
[TD="align: right"]68[/TD]
[/TR]
[TR]
[TD]Michael[/TD]
[TD="align: right"]74[/TD]
[/TR]
[TR]
[TD]Thomas[/TD]
[TD="align: right"]71[/TD]
[/TR]
[TR]
[TD]Mateo[/TD]
[TD="align: right"]74[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Domi[/TD]
[TD="align: right"]82[/TD]
[/TR]
[TR]
[TD]Camilo[/TD]
[TD="align: right"]81[/TD]
[/TR]
[TR]
[TD]Michael[/TD]
[TD="align: right"]74[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]


[TABLE="width: 263"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]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[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]

 

[riverad]

There is an example file here:

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

Does this help?

Cant open this =( =S

 

[FormR]

Cant open this =( =S

I did edit the link after posting, can you try again?

If not - then do you mean the link doesn't work, or that you receive an error when you attempt to open the file, or access to the website is blocked for you, or??

 

[riverad]

I did edit the link after posting, can you try again?

If not - then do you mean the link doesn't work, or that you receive an error when you attempt to open the file, or access to the website is blocked for you, or??

Internet Explorer cannot display the webpage, thats everything i get when i try to open it, nothing else... :S

 

[FormR]

Cant open this =( =S

I have emailed you the example file - hopefully it will work for you. Please post back here with your findings.

 

[riverad]

I have emailed you the example file - hopefully it will work for you. Please post back here with your findings.

Thank you, out of the example i could use the formulaa shown in b13, but somehow a13 wont work, the one for the names to match the numbers,
ive tried changing it, but somehow it doesnt give me an error message but it just stays as formula in the list, it doesnt change to name or anything =S

any ideas why the formula would stay as formula and not take the name??

i already formated the cell to text, general and everyting possible but it will still just show the formula.

 

[FormR]

i already formated the cell to text, general and everyting possible but it will still just show the formula.

Make sure the cell is formatted as general before you enter the formula. If you are copying the formula from somewhere check there are no spaces before the = sign or after the final )