Hi

I've searched around a bit and haven't been able to find anything to solve my problem so was wondering if anyone can help?

I have a number of rankings, all from different spreadsheets that I wish to combine and average out.

Thus far I have pulled all the relevant worksheets into 1 spreadsheet. The issue I'm having is that each worksheet contains slightly different names.

So as an example, Sheet1 may have 4 columns: Bob Hope | 4 | SE | PM |
Sheet 2 may have 2 columns: | Bob Hope, PM, SE | 8 |
Sheet 3 may have 3 columns: | Bob Hope, SE | PM | 9 |

What I need to do is have a master sheet which just pulls through the name and then the average of the scores, i.e.: | Bob Hope | 7 |

I have approximately 400 people that I need to do this with.

Thanks for any advice!