S
SMaule
I just found these forums and They are very informative.
I found several threads that were similar to what i'm trying to do, bu
they wern't able to competely do what I need.
Here is a simplified example
[image: http://stevesite.hopto.org:888/pics/excel_help.jpg]
what I want in the end is to have charts per planet, with best scores
(best skills, best ping.. etc)
I've been trying to get Hlookup, and max, and If's (or whatever woul
work) combined so that in another worksheet, i can have "mars" column
and then have each players highest score,skill, ping, of all the game
they played for each planet. (once I have the highest scores pe
planet, i know how to arrange them in rankings). I have data bein
added to the end of the list every few days also.
I dont know if there is a way to have excel arrange(decending) th
data. say, like:
arrange D:J, according to row 6.. then hlookup for each plane
outputing the score (since the first time if finds each planet it woul
be the highest score and that is all I need)
and repeat for row 7,8.. through 200 or however many players ther
are.
I hope I wasn't too confusing,
thanks for any ideas
-stev
I found several threads that were similar to what i'm trying to do, bu
they wern't able to competely do what I need.
Here is a simplified example
[image: http://stevesite.hopto.org:888/pics/excel_help.jpg]
what I want in the end is to have charts per planet, with best scores
(best skills, best ping.. etc)
I've been trying to get Hlookup, and max, and If's (or whatever woul
work) combined so that in another worksheet, i can have "mars" column
and then have each players highest score,skill, ping, of all the game
they played for each planet. (once I have the highest scores pe
planet, i know how to arrange them in rankings). I have data bein
added to the end of the list every few days also.
I dont know if there is a way to have excel arrange(decending) th
data. say, like:
arrange D:J, according to row 6.. then hlookup for each plane
outputing the score (since the first time if finds each planet it woul
be the highest score and that is all I need)
and repeat for row 7,8.. through 200 or however many players ther
are.
I hope I wasn't too confusing,
thanks for any ideas
-stev