Select the total best score to summarize ?

Hello !

I have two columns and two list-boxes.
You can select in each list-box players which appear in each columns from the table.
Automatically below it should appear the Total best scores from the 3rd column from the table, named Best Scores.
First I want to know how to do this and second I want to know how you could select one player vs multiple players at the same time and automatically summarize their best scores against this single player.

Thank you so much !

PS: Please check the file added as attachment to see what I did.

It works but only for the first step of my problem.
1) I want to know how you could select one player vs multiple players at the same time and automatically summarize their best scores against this single player ? It seem with list-boxes it couldn't be possible...


2) Also, How to avoid repetition in the list-boxes ? e.g on the first list-box "Merkovitz" appears too many times and I want it to be only a single time because I don't need it so many time, just one single time.

Thank you so much !

Originally Posted by Fotis1991

For your second, dont use in data validation,columns D & F. Create 2 lists in other columns with uniques Names and use these list in your validation list.

Just fixed it. :D Thank you !

===>

Originally Posted by Fotis1991

For your first query, i really don't know a way to choose many names from the list at same time.

It is not really compulsory to use a list-box. You can use any type of control or any kind of method you want but the purpose is only one: choose multiple players at the same time. Do you know any other possibility ? Maybe another table with the players or any kind of control, it doesn't matter ?...

Ok, still waiting ! :D

Thank you !

Ok, but this is a simple example but what if you must choose 20 or 30 players from 200 or 300 available ?
Any other method ?
Buttons or multiple check boxes, maybe ?

Thank you !

Originally Posted by Fotis1991

Excusme, but how can i know that when you say"multiply players", in your first post,you mean 20-300? I am not inside your mind not even inside your real workbook...

Did you mentioned somewhere and i didn't see it?

I saw a workbook and i tried to help on this... and your answer is " Ok, but......."

I'm so sorry for this.
In fact, want I really want to do is this:

Doc1.docx
Sorry I'm not writing anything but I tried so many times and I couldn't succeed in posted what I want. I don't know why...
That's why I am uploading right now exactly what I want to say and I couldn't post here directly.
Check the attachment, please !

And the real workbook is this:Hands.xlsx

But what I want to do is exactly something like this: (file/problem posted here, in this topic)
Book1.xlsx It is identical to it.

Could you help me, please ?

Thank you so much for your help and sorry for this !

BUMP Anyone, please ?

None ?
Look, I want to make a matrix like that from this file added as attachment but to be able to select multiple values from it in order to do some math with them. How to do that ? Any help, please ?

Thank you very much in advance !

none ? The message you have entered is too short. Please lengthen your message to at least 10 characters.