Hi, I've got another problem which I can't figure out :)

I have a hockey scoring sheet, which has player names, goals and assist
with it. What I want to do, is to print in to a different sheet player's
name and goal amount, who has scored the most goals.

Example of a scoring sheet:

Code:
--------------------
----A---- ----B---- ----C----

Player Goals Assists

Jagr 33 43
Staal 33 36
Alfredsson 32 38
Kovalchuk *35* 33
Heatley 32 36
Ovechkin 34 31
--------------------


The generated result I'm looking for would look like this:

Code:
--------------------
----A---- ----B---- ----C----

Player Goals Assists

Kovalchuk 35 33
--------------------


I know this sounds silly, but what I need is more complicated than this
and I want to search the best scorer overall from different result
sheets. I want to do daily/monthly/ect statistics so Pivot Point system
isn't useful (Or at least I think so). The generated sheet should always
change if someone else has scored more goals.

Is this possible to do with a normal excel function?


--
Handyy
------------------------------------------------------------------------
Handyy's Profile: http://www.excelforum.com/member.php...o&userid=30958
View this thread: http://www.excelforum.com/showthread...hreadid=507942