Too ambitious?

  • Thread starter Thread starter Neil G
  • Start date Start date
N

Neil G

My spreadsheet has a Worksheet for each year of an event, in which
competitors can obviously be present on multiple sheets, dpending on
qualification.

I would like a summary sheet that can take the competitors score per year -
so I guess I'm looking for some form of lookup, and sum them to get an
overall score for each person.

Ideally, the summary should enter any new names when they appear on yearly
sheets, and then the cell on the summary under a yearly column would enter
the final score from the yearly sheets scorechart.

Is this feasible?

Any ideas's for implementation.

Thanks
Neil
 
A pivot table would do the job. Data/Pivot Table Report.

I would put all the data into one sheet for this, otherwise you can us
the Multiple Consolidation Ranges option
 
Back
Top