average of specific cells in various columns

[ngs007]

Hi
I am trying to find the average of a cell with a name in that may appear several times in various columns. I then need to find the average of the value against that name in all the columns that it occurs in. This needs to be dynamic as new names and values are added it can recalculate Example:
a b c d e f g h i j k l
Aldridge Sean 2 3 3 Andrew Rob 4 3 3 Aldridge Sean 3 2 2
Andrew Rob 1 2 2 Aldridge Sean 3 2 4 Andrew Rob 2 2 3 4
smith bill 4 3 3 jones harry 3 2 2 Aldridge Sean 1 1 2

so in the above I want to find the average score for aldridge sean in column c, g and k. Then if more names and data are added I want this to recalculate automatically
hope you can help!

[oeldere]

Why not add all information in 3 columns (instead of 12).

Then pivot table could do the job for you.

[ngs007]

Thanks but this is not possible - they have to be spaced out as the other data cannot move. The example i gave is just an example rather than actual problem

[oeldere]

show us an excel eample, without confidental information.

please also add the desired (expected) result.

[oeldere]

Read the forumrules, specaly the rules for crossposting.

See the link below.

http://www.mrexcel.com/forum/excel-q...t-columns.html


Please read the forumrules according to crossposting.
You find the forumrules in the link below.
http://www.excelforum.com/forum-rule...rum-rules.html

Please also take the time to read this article of Ken Puls.
A message to forum cross posters
http://www.excelguru.ca/content.php?184

[ngs007]

Hi
Sorry about that - i didn't realise. I will make sure I do this in future. Thanks for your help and advice - post closed