In column B i have a list of numbers eg. 671, 672, 673 etc. these numbers are repeated a number of times. In column O I have a list of numerical numbers that i need to work out the averages for.
So i need a formula that looks up all the 671's in column B and takes their scores from column O and works returns the average.
So i need a formula that looks up all the 671's in column B and takes their scores from column O and works returns the average.