Hi there. First of all I want to say thanks for all the help people on this forum have given me so far. I have learned so much and you are all wonderful.
Now the problem I have.
I have 2 sheets recording feedback and summarising the overall percentages for each trainer.
My boss wants me to do this by month!?!?!
I have created a third sheet but I am not sure how to do the following:
- Look up the trainer name
- Look up the month
- identify the percentages for each category
- create an overall average of these percentages
So for example if Jon smith trained twice in JAN getting 100% and 50% in cat1, it would display 75% in the cat 1 cell and so on.
I have attached the file.
Once again thank you so much.
Simon
Bookmarks