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!

Without a total layout description it is hard to give an exact answer
You can get data from a table with VLOOKUP
You can get data from another sheet with references in the form Sheet2!A1 or
'Sheet Five'!A1 when the sheet name has a space in it.
Try to combine these
Or tell us the exact data layout
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JDB" wrote in message
...
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!

Hi,

Hope this helps!

Each row is the result of a measured telephone call - the call is scored in
various areas and the total score is presented at the end of the row. The
columns are the measures, the name of the checker, the date, time, call ID,
call handler ID and team.

The rows contain a mixture of numbers and text, although I only need to
provide the average score per team for that particular month (there is one
sheet per month).

The data I need is team name which is held in column Z and the total score
which is held in column AA.

Calls are entered onto the sheet as they are measured and as they are
measured using a dip sample, there is no order to the list. I have tried to
perform a sort but ended up breaking the sheet!

I'm really stuck with this! So thanks for your help!!

"Bernard Liengme" wrote:

Without a total layout description it is hard to give an exact answer
You can get data from a table with VLOOKUP
You can get data from another sheet with references in the form Sheet2!A1 or
'Sheet Five'!A1 when the sheet name has a space in it.
Try to combine these
Or tell us the exact data layout
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JDB" wrote in message
...
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!

A pivot table would work nicely for what I think you are looking for. Once
set up you could easily get team averages. A 'Help' or 'Web' will give you a
lot of information on how to do this.
--
T Tipsy


"JDB" wrote:

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!

Thanks for this. Created a pivot table and it works just fine. !
"Terry Tipsy" wrote:

A pivot table would work nicely for what I think you are looking for. Once
set up you could easily get team averages. A 'Help' or 'Web' will give you a
lot of information on how to do this.
--
T Tipsy