pete_bristol
02-15-2006, 02:18 AM
Hi,
I've been getting to grips recently with array formulas and curly brackets.
I understand, for instance, that if i wanted to sum the top three entries in a range A1:A10 i would enter the formula @sum(large(A1:A10,{1,2,3})).
However, what if i wanted to specify the {1,2,3} as "variables".
I think i have tried just about every conceivable way of replacing the {1,2,3} with cell references, INDIRECT() etc, but with no joy.
Perhaps it is not possible?
I would really appreciate your help.
Regards,
Pete
I've been getting to grips recently with array formulas and curly brackets.
I understand, for instance, that if i wanted to sum the top three entries in a range A1:A10 i would enter the formula @sum(large(A1:A10,{1,2,3})).
However, what if i wanted to specify the {1,2,3} as "variables".
I think i have tried just about every conceivable way of replacing the {1,2,3} with cell references, INDIRECT() etc, but with no joy.
Perhaps it is not possible?
I would really appreciate your help.
Regards,
Pete