row-indirect functions
This is an array formula, which means that you should type the
following:
= MIN(Data)+(ROW(INDIRECT("1:10"))*(MAX(Data)-MIN(Data)+1)/10)-1
but instead of pressing ENTER as normal, you should do CTRL-SHIFT-ENTER
at the same time. If you do it properly then Excel will wrap the curly
braces { } around the formula (do not type these yourself). If you need
to edit the formula, you should do C-S-E again, but you can copy and
paste the formula normally.
Hope this helps.
Pete
|