Nick,

The best solution would be to insert a column of formulas

=B2(AVERAGE(B:B)+STDEV(B:B))

and then use Data Filter Autofilter and select TRUE for that column.

HTH,
Bernie
MS Excel MVP


"Nick" wrote in message
...
Hello

Please help.

I'm trying to program Excel to run down a column of values, taking values
that are over average(values) + stdev(values) and populating another
worksheet with the adjacent reference for these values.

for example

If I have company registration numbers in one column and their credit risk
rating in another column. I want excel to populate another worksheet with the
company names that have a credit risk rating which is above average(values) +
stdev(values).

I can do this manually, but I want add a button so that my colleagues can
perform the same action with exactly the same result.

Any hints would be much appreciated and I would be will to make a donation

Many thanks in advance, Nick