Sum Question

gr_zaki

New Member
Joined
Nov 2, 2002
Messages
44
i want to have a table with 100 entries with scores of 10 people names and all the scores of them end i want to have in a cell the fisrt score of a player and in another cell the second score of the player and so on for all the matches he made.

example:

misterA 1
misterB 2
MisterC 5
MisterD 2
MisterA 1
MisterB 1
MisterA 2
MisterD 2
MisterA 6

I want Only the first Score of MisterA in a cell
I want Only the second Score of MisterA in a Cell
I Want The Only The Seconf Score of MisterB in a cell

Thanks a lot for reading my Post
be well :)
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

eliW

Well-known Member
Joined
Mar 2, 2002
Messages
1,934
On 2002-11-03 05:30, gr_zaki wrote:
i want to have a table with 100 entries with scores of 10 people names and all the scores of them end i want to have in a cell the fisrt score of a player and in another cell the second score of the player and so on for all the matches he made.

example:

misterA 1
misterB 2
MisterC 5
MisterD 2
MisterA 1
MisterB 1
MisterA 2
MisterD 2
MisterA 6

I want Only the first Score of MisterA in a cell
I want Only the second Score of MisterA in a Cell
I Want The Only The Seconf Score of MisterB in a cell

Thanks a lot for reading my Post
be well :)
Hi gr_zaki and welcome to the board,

Look at the example below:
Eli
Book1
ABCDEF
1PLAYERSCOREPLAYERBESTSECOND
2A1A42
3B2B87
4C3C63
5D4D54
6A2
7C6
8B8
9D2
10A1
11B7
12C3
13A4
14D5
Sheet1
 

eliW

Well-known Member
Joined
Mar 2, 2002
Messages
1,934
I forgot to mention that you must to ARRAY enter those formulae, by pressing at the same time on CTRL+SHIFT+ENTER
Eli
 

gr_zaki

New Member
Joined
Nov 2, 2002
Messages
44

ADVERTISEMENT

Thanks a lot friend
i am quite new to this board and still learning thank a lot for your help i'll try your Function right now!
:)
 

gr_zaki

New Member
Joined
Nov 2, 2002
Messages
44
i think my question to the board wasn't understood because of the explaination i gave to you. I don't want the best score of the players i want the first score then the second score based on the date the match was taken.
Thanks a lot for your time and i apologise for my first wrong question...
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234

ADVERTISEMENT

why not just sort the table? Do you have a date field you can use (to indicate the order the scores came in?)

paddy

EDIT: although I don't suggest it for this task, you could also review the 'arbitrary lookups' section on Chip's site:

http://www.cpearson.com/excel/lookups.htm#DoubleLookup
This message was edited by PaddyD on 2002-11-03 18:08
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
On 2002-11-03 17:50, gr_zaki wrote:
i think my question to the board wasn't understood because of the explaination i gave to you. I don't want the best score of the players i want the first score then the second score based on the date the match was taken.
Thanks a lot for your time and i apologise for my first wrong question...

I'm afraid it's still unclear what you want. You could give the expected results with respect to the sample you provided in your original post.

Just curious: Is the following post (with zaki as poster) is also yours:

http://216.92.17.166/board/viewtopic.php?topic=27693&forum=2 ?
 

gr_zaki

New Member
Joined
Nov 2, 2002
Messages
44
nope this post is not mine :)
let me explain better the situation

i have a league let's say the english premier league it includes date, teams,RATE and the results in one sheet for example
May 13,2002 Arsenal - Manchester United 1 - 1
i have 1000 results like this of all the teams that the premier league has.

"The rate is a coloum next to the score colum and the number of rate of each team for each match goes with a type based on my critiria..."

Now i want in a seperate sheet to have the team name and the RATE that the took get from the begining of the season up to now lets say it played 9 matches and in the first it took 5 in the second 3 in the third 0 and so on...
i want the procedure to be automated for all the teams of this league that's way i am searching for the type...

I hope i explained well the situation thanks again for reading :)
 

Forum statistics

Threads
1,143,614
Messages
5,719,720
Members
422,242
Latest member
hishamkhatri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top