Hi All,

As with most things, the answers received from my last post have only led to more questions........

I am using the following formula (in cell J45) to work-out the average score from a round of shooting for the members of our shooting club:-

=AVERAGEIF(J2:J44,">0")

At the end of each shoot we give out a prize for Mr Average i.e. the person who shot the closest score to the days average.

Is there a formula that I can use to highlight the score within cells J2:J44 that is closest to the average score displayed in cell J45?

Thanks in advance for your help.

Simon.