What I am trying to accomplish is probably stupidly easy but it has been so long since I have worked with Excel I have forgotten nearly everything you can do with it and more importantly, how to do it.
I have been playing around with Microsoft Excel 2007 for a number of hours now trying to recall as much as I could but I could not accomplish what I want to achieve and am now seeking the guidance and support of those who would give it.
The best way I can describe this is organizing a ranking for stats for a first person shooter game.
Column A would contain Names of players. Column B would contain a number for kills. Column C would contain a number for deaths. Another for number of medals, flag scores, whatever.
Now each row for the data input would represent the results of a given game.
Example with Columns separated by commas.
Name, Kills, Deaths, Head Shots, Medals
Dronzer, 8, 2, 4, 10
ANoob, 13,2,5,15
Now, a player name could be entered multiple times (and they will) with varying values for the Data for the game.
What I can't figure out is how to crunch all of the stats for a given player into one line instead of sorting (and having multiples entries for a name and manually using the SUM function to get what I need).
My vision is all the data gets entered into Sheet 1 and Sheet 2 mimics sheet 1 but it has all the players listed only once and all the numbers listed from Sheet 1 for a given player totaled on Sheet 2, allowing you to sort and see who has the most kills, the most deaths, etc as you so desire.
Anyone have any ideas on how to accomplish this? I used to know how to do this long ago but forgot how. I haven't had a lot of use with Excel 2007 and used an older version where the Name function was used or something?
Thank you kindly in advance for your ideas, support, and assistance in helping me with this likely simple problem.
I have been playing around with Microsoft Excel 2007 for a number of hours now trying to recall as much as I could but I could not accomplish what I want to achieve and am now seeking the guidance and support of those who would give it.
The best way I can describe this is organizing a ranking for stats for a first person shooter game.
Column A would contain Names of players. Column B would contain a number for kills. Column C would contain a number for deaths. Another for number of medals, flag scores, whatever.
Now each row for the data input would represent the results of a given game.
Example with Columns separated by commas.
Name, Kills, Deaths, Head Shots, Medals
Dronzer, 8, 2, 4, 10
ANoob, 13,2,5,15
Now, a player name could be entered multiple times (and they will) with varying values for the Data for the game.
What I can't figure out is how to crunch all of the stats for a given player into one line instead of sorting (and having multiples entries for a name and manually using the SUM function to get what I need).
My vision is all the data gets entered into Sheet 1 and Sheet 2 mimics sheet 1 but it has all the players listed only once and all the numbers listed from Sheet 1 for a given player totaled on Sheet 2, allowing you to sort and see who has the most kills, the most deaths, etc as you so desire.
Anyone have any ideas on how to accomplish this? I used to know how to do this long ago but forgot how. I haven't had a lot of use with Excel 2007 and used an older version where the Name function was used or something?
Thank you kindly in advance for your ideas, support, and assistance in helping me with this likely simple problem.
