Hi,

I am looking for a way to create a sheet (which I'll call A) to read data
from another sheet (which I'll call B).

The data in B is team scores. What I need to do is record on sheet A the
results from the teams in B. The scores on sheet B are not in team order (for
example, the results for team 1 are in column AA but on rows 1, 6, 8, 20 and
so on). Is there a formula that I can use to read the data for each team and
present an average score on sheet A with one column for team name and one
column for average score?

I'd be grateful for some help. Oh, and a Happy New Year to you all!