Find Max result, multiple listings

  • Thread starter Thread starter SMaule
  • Start date Start date
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
 
Steve,

Here's a macro (don't remember where I got it)

Sub SaveAsPDF()
' Define the postscript and .pdf file names.
Dim PSFileName As String
Dim PDFFileName As String
PSFileName = "C:\myPostScript.ps"
PDFFileName = "C:\myPDF.pdf"

' Print the Excel range to the postscript file
Dim MySheet As Worksheet
Set MySheet = ActiveSheet
ActiveSheet.PrintOut copies:=1, preview:=False, _
ActivePrinter:="Acrobat Distiller", printtofile:=True, _
collate:=True, prtofilename:=PSFileName

' Convert the postscript file to .pdf
Dim myPDF As PdfDistiller
Set myPDF = New PdfDistiller
myPDF.FileToPDF PSFileName, PDFFileName, ""

Kill (PSFileName)

End Sub

You need to add a reference to Acrobat Distiller.

Dan E
 
Posted to the wrong thread, my apologies!

Dan E

Dan E said:
Steve,

Here's a macro (don't remember where I got it)

Sub SaveAsPDF()
' Define the postscript and .pdf file names.
Dim PSFileName As String
Dim PDFFileName As String
PSFileName = "C:\myPostScript.ps"
PDFFileName = "C:\myPDF.pdf"

' Print the Excel range to the postscript file
Dim MySheet As Worksheet
Set MySheet = ActiveSheet
ActiveSheet.PrintOut copies:=1, preview:=False, _
ActivePrinter:="Acrobat Distiller", printtofile:=True, _
collate:=True, prtofilename:=PSFileName

' Convert the postscript file to .pdf
Dim myPDF As PdfDistiller
Set myPDF = New PdfDistiller
myPDF.FileToPDF PSFileName, PDFFileName, ""

Kill (PSFileName)

End Sub

You need to add a reference to Acrobat Distiller.

Dan E

SMaule > said:
I just found these forums and They are very informative.

I found several threads that were similar to what i'm trying to do, but
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 would
work) combined so that in another worksheet, i can have "mars" column,
and then have each players highest score,skill, ping, of all the games
they played for each planet. (once I have the highest scores per
planet, i know how to arrange them in rankings). I have data being
added to the end of the list every few days also.

I dont know if there is a way to have excel arrange(decending) the
data. say, like:
arrange D:J, according to row 6.. then hlookup for each planet
outputing the score (since the first time if finds each planet it would
be the highest score and that is all I need)
and repeat for row 7,8.. through 200 or however many players there
are.

I hope I wasn't too confusing,
thanks for any ideas
-steve
Click to expand...
Click to expand...
 
Back
Top