View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] nicholas.deselle@gmail.com is offline
external usenet poster
 
Posts: 1
Default Please help me win my fantasy football league by answering this excel ?

Thanks in advance for any help. Here is my challenge. I want to
track stats for players on rows. Have a different row for each of the
last three seasons (They are in the same columns so I can data sort
and all of player x's stats for the lest three seasons are in three
rows. How do I get Excel to recognize that the value (a-z) in the
name field matches and THEN average together one cell from each of the
three rows.

e.g. 06 Jo Johnson 48
05 Jo Johnson
57


How do I write one cell that excel will know is asking me to average
all of the number values if the names match?

I am a rookie so if this one is obvious I apologize.

NJD