Hi

=IF(A2=AVERAGE($A$2:$A$100),"yes","no")
Copy down as required
--
Regards
Roger Govier

"Bojan" wrote in message
...
Hi,
I'm doing a report with monthly averages for each team. What I want is
when
an average number is met at A2,... A3, ... to show "yes" or "no" something
like this:
A2 A3
123 yes
95 no
150 yes