Yeah, I think it does. Last review, then: Sheet1 (let's say) has employee

name in column A, plus maybe a few more demographic columns - department,

employee number, phone, whatever, I don't care about that - and then in say

columns D through M there are ten performance categories; in each of the 500

employee rows, that employee receives a numerical rating in each of the 10

categories. Between the 500 employee rows and the column header(s) at the

top you've saved room for AVERAGE(D4

503) in D2:M2, and in each column of

D3:M3 you have the standard deviation. And out in column N, perhaps, you

calculate for each employee a "total value" based on that employee's

performance ratings, weighted to your satisfation.

Now comes a manual process: You sort the 500 employees on column N, the

best numbers at the top. Then you have to have the AVERAGE and STDEV

calculations in rows 2 and 3 reflect not all 500 rows but just the first 100;

you figure that out and probably PasteSpecial the values (not the formulae)

into rows 2 and 3, so that during the following steps those values will be

preserved. After that you're free to sort all 500 rows back into whatever

order you want them in; rows 2 and 3 now represent mean and stdev for just

the top 100 employees.

Back to automatic processes: On (let's say) Sheet2, D4:M503 display each

employee's rating in each category in plus-or-minus sigs intead of a raw

number, based on the new values in rows 2 and 3 of Sheet1. Sheet2 is what

you actually look at for analysis.

This process works, but you're hoping to minimize the manual work, or even

eliminate if possible. Right?

Well, I haven't yet asked how you're plugging in the second set of mean and

stdev formulae - for the top 100 employees, I mean. I hope you have them

permanently prepared, so all you have to do is a PasteSpecial one time. But

at any rate, I've tried the following and think it would work: Instead of

pasting the new top-100 means and stdev in rows 2 and 3 of Sheet1, put them

in rows 2 and 3 of Sheet2, though still calculating on the first 100 rows in

Sheet1. (Eg "=AVERAGE(Sheet1!D$4

$103)".) I've tested this and the

formulae in Sheet2 seem to keep looking at rows 4 through 103 even after I

sort the rows in Sheet1, with the result that the Sheet2 means and stdevs

change as you'd expect. Then your sig calculations in Sheet2!D4:M503 will, I

believe, show the results you want, without ever having to do manual pasting

and recalculation; just a sort will do the trick.

Is that clear?