EXCEL HELP

[BERTRAND]

Hi
In the scenario below, how can I auto-insert the "RANGE"(X:X) inside the STDEV function which corresponds to the references in column A?

------A-------------B
102138414 _ _ 4.1
102138414 _ _ 2.5
102138414 _ _ 3.34
102138414 _ _ 17.5 (STDEV(B1:B4)
102141171 _ _ 1.24
102141171 _ _ 16.84
102141171 _ _ 49.55
102141171 _ _ 750.44
102141171 _ _ 158.67
102141171 _ _ 7.71 (STDEV(B5:B10)
102138416 _ _ 319.46
102138416 _ _ 6.21
102138416 _ _ 12.44
102138416 _ _ 1.54
102138416 _ _ 10
102138416 _ _ 70.13
102138416 _ _ 319.44 (STDEV(B11:B17)

Thanks in advance
Bert

[alrodopial]

At the last row of every "group" eg In row 4 place in C4 a formula that will calculate the first row of the current group ( number 1) and in cell D4 a formula that will calculate the last row of the current group ( number 4)

your formula in E4 will be:

Code: Select all

=STDEV(INDEX(B:B,C4):INDEX(B:B,D4))

[BERTRAND]

Many Thanks Alrodopial
Bert