Hi Guys,
I am working on this worksheet that would collect a listing of scores given to items.
The list can have multiple occurrences of different items.
The idea is that all those scores could be gathered in an average value on another sheet.
Here for example, I wish that that blue highlighted box below contains automatically an average to the lower grade (in case the result doesn't exactly match a grade, I don't want halves) of the values in the tables above concerning "Frog Morton on The Town". In this case, I'd like this bow to show "1 - Extremely Mild".
These values are prelisted in a range for validation purposes.
Would anyone have an idea?
Thanks a lot.
Carver.
I am working on this worksheet that would collect a listing of scores given to items.
The list can have multiple occurrences of different items.
The idea is that all those scores could be gathered in an average value on another sheet.
Here for example, I wish that that blue highlighted box below contains automatically an average to the lower grade (in case the result doesn't exactly match a grade, I don't want halves) of the values in the tables above concerning "Frog Morton on The Town". In this case, I'd like this bow to show "1 - Extremely Mild".
These values are prelisted in a range for validation purposes.
Would anyone have an idea?
Thanks a lot.
Carver.