Hi,

I have a sheet of data with team names in one column and the data relating
to these teams in other columns. Each row is a scored telephone call taken by
individual team members. What I need to do is count the number of time each
team name appears on the list and display this on another 'Results'
worksheet. I have a pivot table that can give me that, but I need to display
the data on the 'Results' sheet which contains other data too.

Any ideas?